Learn about using Mapping Data Flows in Azure Data Factory.
When you work with ETL and the source file is JSON, many documents may get nested attributes in the JSON file. Your requirements will often dictate that you flatten those nested attributes. There are many ways you can flatten the JSON hierarchy, however; I am going to share my experiences with Azure Data Factory (ADF) […]
Learn how to gather metadata information about the files being processed in your ADF pipeline.
There is a Power Query activity in SSIS and Azure Data Factory, which can be more useful than other tasks in some situations.
This article will help you to work with Store Procedure with output parameters in Azure data factory.
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 […]