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
4,491 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
9,888 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
20,494 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
23,725 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
4,460 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
34,951 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
22,533 reads
Blogs
AI and Data Engineering on the Edge: The Good, the Bad, and the Overhyped
Running AI and data pipelines on the edge instead of the cloud has gone...
UNION vs UNIONALL: #SQLNewBlogger
By Steve Jones
While writing another post I realized my UNION query didn’t work as one might...
Deciphering Data Architectures Is Now Available in Multiple Languages
By James Serra
Since the release of my book Deciphering Data Architectures: Choosing Between a Modern Data...
Forums
Malegra 200 mg – High-Strength Sildenafil Tablets
Malegra 200 mg contains sildenafil citrate, a widely used medication for the treatment of...
Secure Cached Plans
Comments posted to this topic are about the item Secure Cached Plans
Complex Data Processing with dbt Python Models: The Fabric Modern Data Platform
Comments posted to this topic are about the item Complex Data Processing with dbt...
Question of the Day
Secure Cached Plans
The DMV, sys.dm_exec_cached_plans, contains rows for each cached plan on an instance. In Azure SQL Database, not every used has rights to every database, as there does exist an instance behind each database. How is security handled for this DMV in Azure?
See possible answers