ETL/SSIS/Azure Data Factory

SQLServerCentral Article

How to simulate Case statement in Azure Data Factory (ADF) compared with SSIS?

  • Article

This post will describe how you use a CASE statement in Azure Data Factory (ADF). If you are coming from SSIS background, you know a piece of SQL statement will do the task. However let's see how do it in SSIS and the very same thing can be achieved in ADF. Problem statement For my […]

4.5 (2)

2020-11-12

10,189 reads

SQLServerCentral Article

Incremental Data Loading using Azure Data Factory

  • Article

Introduction In my last article, Loading data in Azure Synapse Analytics using Azure Data Factory, I discussed the step-by-step process for loading data from an Azure storage account to Azure Synapse SQL through Azure Data Factory (ADF). ADF basics are covered in that article. In this article I will go through the process for the incremental […]

4.5 (2)

2020-09-24

21,540 reads

SQLServerCentral Article

Modular ETL Architecture Design in SSIS

  • Article

Overview of ETL Architecture In a data warehouse, one of the main parts of the entire system is the ETL process. ETL is the system that reads data from the source system, transforms the data according to the business logic, and finally loads it into the warehouse. While fetching data from the sources can seem […]

4 (2)

2019-10-21

13,252 reads

Blogs

Storage Field Day 23 – SIOS

By

I am thrilled to have been a part of this year’s Storage Field Day...

Getting a list of the articles in a publication.

By

The other day I was asked to supply a list of all of the...

Daily Coping 17 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

bestpoststore

By bestpoststore

That's great, I like it so much, come on!putting a balance in life may...

SSRS permissions basics

By cb122

Is it possible via a query, specific to 'SSRS' (SQL Server Reporting Services) to...

Azure SQL Database Differential Backup Frequency

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Azure SQL Database Differential Backup...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers