Azure Data Factory Interview Questions and Answers
Get a few common questions and possible answers about Azure Data Factory that you may encounter in an interview.
2022-06-03
683 reads
ADF
Understanding the Mapping Data Flow Activity in Azure Data Factory
Learn about using Mapping Data Flows in Azure Data Factory.
2022-04-25
1,723 reads
How to Flatten JSON 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) […]
2021-09-17
7,806 reads
Working with Get Metadata Activity in Azure Data Factory
Learn how to gather metadata information about the files being processed in your ADF pipeline.
2021-08-20
8,124 reads
Why Power Query as an Activity in Azure Data Factory and SSIS?
There is a Power Query activity in SSIS and Azure Data Factory, which can be more useful than other tasks in some situations.
2021-07-26
3,363 reads
Reading Stored Procedure Output Parameters in Azure Data Factory
This article will help you to work with Store Procedure with output parameters in Azure data factory.
2021-04-06
14,394 reads
How to simulate Case statement in Azure Data Factory (ADF) compared with SSIS?
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 […]
2020-11-12
10,863 reads
Exporting Azure Data Factory (ADF) into TFS Source Control
Have you created a Data Factory in Azure and are wondering how to get it into TFS and source control? This article will show you how.
2016-04-18
3,476 reads
SQL OUTPUT
I want to write select store procedure with 4 columns Passing a single variable and returning all the 4 columns as an output can someone help mehow to return 4 coulmsn for example:create proc test@id int output,@name char(10) output,@city char(20) output,@state char(2) outputasselect id,name,city,state from test_table where id = @id???????????
2004-09-30
Blogs
Not Selected for the PASS Data Community Summit 2024
By Steve Jones
I got this in an email about a week ago from the PASS Data...
A New Word: Addleworth
By Steve Jones
addleworth – adj. unable to settle the question of whether you’re doing okay in...
Data Technology Learning Resources
Hey all! Quick one here. Tracy Boggiano, awesome person that she is, has put...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers