#1. Azure Data Factory Vs. SSIS - Simple Explanation

#2. Azure Data Factory - What is Storage Account, Resource Group, BLOB, Data Lake?

#3. Azure Data Factory - How to create a data factory? How does the ADF portal look like?

#4. Azure Data Factory - Create your first Pipeline

#5. Azure Data Factory - Use Foreach loop activity to copy multiple files - Step by Step Explanation

#6. Azure Data Factory - What is integration runtime? What are its types?

#7. Azure Data Factory - Connect cloud to On Premise SQL Database

#8. Azure Data Factory - Load data from On Premise SQL table to Azure Blob Storage

#9. Azure Data Factory - Introduction to Array type variables

#10. Azure Data Factory - Learn simple expressions and Dynamic Datasets

#11. Azure Data Factory - Append current date to Filename

#12. Azure Data Factory - Use lookup activity to decide on subsequent activities

#13. Azure Data Factory - Use If condition in Pipeline

#14. Azure Data Factory - Debug until an activity in pipeline

#15. Azure Data Factory - Delete contents of a folder

#16. Azure Data Factory - Append & Set Variable activities

#17. Azure Data Factory - Canvas properties

#18. Azure Data Factory - Creating a SQL Database in Cloud and understanding DTUs

#19. Azure Data Factory - Load from On Premise SQL table to Azure SQL table

#20. Azure Data Factory - Load from .XLSX file to Azure SQL table

#21. Azure Data Factory - Use Switch cases in Pipeline

#22. Azure Data Factory - Use Filter Activity to filter .txt files from Folder

#23. Azure Data Factory - Wait activity to Pause Pipeline execution

#24. Azure Data Factory - Until Activity in ADF - Real time scenario

#25. Azure Data Factory - Copy records to COSMOS database

#26. Azure Data Factory - Product table with different attributes in COSMOS DB

#27. Azure CosmosDB- Enable replication in Cosmos DB

#28. Difference between IAAS, PAAS and SAAS in Azure Perspective

#29. Azure Cosmos DB - Consistency levels in Cosmos DB

#30. Azure Data Factory - What is a Data Flow activity? Compare with SSIS!

#31. Azure Data Factory - Mapping data flow with Derived column transformation added

#32. Azure Data Factory - Conditional Split in Data Flow Activity

#33. Azure Data Factory - Use Union in the data flow activity to combine data from different sources

#34. Azure Data Factory - Optimize Data Flow Activity

#35. Azure Data Factory - Fix Mapping Column issue in Mapping Data Flow

#36. Azure Data Factory - Data Preview tab in Mapping Data Flow

#37. Azure Data Factory - Use Group By in Mapping Data Flow task

#38. Azure Data Factory - Column Patterns in Aggregation to make it simpler

#39. Azure Data Factory - Pivot Transformation in Mapping data flow

#40. Azure Data Factory - Capture Changes to the Source File Metadata without changing Data flow

#41. Azure Data Factory - Unpivot transformation in Mapping data flow

#42. Azure Data Factory - Exception\Error Handling Basics

#43. Azure Data Factory - Implement Error Handling in Pipeline

#44. Azure Data Factory - Get Files that were LastModified one day before!

#45. Azure Data Factory - Flatten Transformation in Mapping Data Flow

#46. Azure Data Factory - Select Transformation to Choose/Rename/Reorder columns in Mapping Dataflow

#47. Azure Data Factory - Use Filter activity inside Mapping data flow task

#48. Azure Data Factory - Use Alter Row transformation to delete NULL records in XL file

#49. Azure Data Factory - Implement Upsert logic in Mapping data flow.

#50. Azure Data Factory - Generate Sequence numbers in Mapping data Flow with Surrogate Key activity

#51. Azure Data Factory - Use Event triggers to copy files coming in different times

#52. Azure Data Factory - Implement schedule triggers in ADF

#53. Azure Data Factory - Differences between Schedule trigger and tumbling window trigger

#54. Azure Data Factory - Demo of tumbling window trigger

#55. Azure Data Factory - Parse XML file and load to Blob storage path

#56. Azure Data Factory - Copy File from On Premise to Cloud

#57. Azure Data Factory - Load from BLOB storage path to SQL Server OnPremise.

#58. Azure Data Factory - Incremental File Copy using Copy Data TOOL

#59. Azure Data Factory - Get Last Modified Date of all Files in a Folder

#60.Azure Data Factory - Incremental Data Load using Lookup\Conditional Split

#61. Azure Data Factory - Data Migration to Azure SQL tables using Lookup file

#62. Azure Data Factory - Data Migration from On Prem SQL to Azure SQL Database

#63. Azure Data Factory - Log error information to csv file using data flow parameter

#64. Azure Data Factory - Add Additional columns to the source columns in Copy Activity

#65. Azure Data Factory - Log error information to csv file using Copy Activity

#66. Azure Data Factory - Implement Master Child Relationship in ADF

#67. Azure Data Factory - Load data from multiple XL sheets to Azure SQL table

#68. Azure Data Factory - Check if all rows got copied when using Copy Activity

#69. Azure Data Factory - Ignore records with data type mismatch\ Primary Key Violation when copying

#70. Azure Data Factory - Compare SSIS Data Flow Task, ADF Data Flow Activity

#71. Azure Data Factory - Copy from CSV file to Azure Synapse table

#72. Azure Data Factory - Reject and Log dirty rows while using "Polybase" option in Copy activity

#73. Azure Data Factory - Dynamically Load from XL sheets to different SQL table

#74. Azure Dat Factory - Merge Multiple CSV files to single CSV file using Copy activity

#75. Azure Data Factory- Split input file to multiple files using a single sink in Mapping data flow

#76. Azure Data Factory - Templates makes our job simpler

SSIS + Azure Storage: Load file from Azure Storage to On Prem data store using SSIS Package

#77. Azure Data Factory - Apply business logic and Rename a file

#78. Azure Data Factory - Execute Python script from ADF

#79. Azure Data Factory - Tips for dataflow design with huge file

#80. Azure Data Factory - Call Azure Function from Pipeline to Compute Series sum

#81. Azure Data Factory - Parse input files with custom delimeters

#82. Azure Data Factory - Nested Foreach loop activity to delete files in multiple folders

#83. Azure Data Factory - Unzip .zip files using Copy activity in ADF

#84. Azure Data Factory: Create .zip file from a folder

#85. Azure Data Factory - Validate File Structure Before Processing it

#86. Azure Data Factory - Single Mapping data flow activity with parameter to handle different files

#87. Azure Data Factory - Use Filter activity with these expressions to filter a text file content

#88. Azure Data Factory - CreateArray() & Join() Functions and its purpose in ADF Pipeline

#89. Azure Data Factory - Process Fixed length/width file in ADF in 2 steps

#90. Azure Data Factory - Create dynamic folders and move files after copy

#91. Azure Data Factory: Copy File From HTTP Server to ADLS

#92. Azure Data Factory - Create Year/Month/Day folder dynamically in Copy activity

#93. Azure Data Factory - Parquet file basics and Convert .txt to .parquet

#94. Azure Data Factory: Implement SCD Type II

#95. Azure Data Factory - Copy the latest file with DATE PART to Folder using AZURE FUNCTIONS

#96. Azure Data Factory - Use Azure Key Vault From ADF

#97. Azure Data Factory - Add Last Modified date of file to Sink data store

#98. Azure Data Factory - Access Azure File Storage from Data factory

#99. Azure Data Factory - Validation Activity to scan folders

#100. Azure Data Factory - Extract date part from filename and Convert to Date format

#101. Azure Data Factory - Split/Partition big file to smaller ones using Mapping data flow

#102. Azure Data Factory - Handle Lookup with more than 5000 records using Loop

#103. Azure Data Factory - Lift & Shift SSIS package from on prem to Azure- Package deployment model

#105. Lift and Shift SSIS Package from SSDT to ADF - Project Deployment Model

#106. Dynamic Column Mapping in Copy Activity

#107. Copy Delimited file with TRAILING DELIMITER using copy activity

#108. Azure Data Factory - How to handle Boolean values in Mapping data flow?

#109. Azure Data Factory - Split/Merge Rows based on a COLUMN in Mapping data flow.

#110. Azure Data Factory - IMPORTANT tips to use SORTING in Mapping Data Flow

#111. NULL error with no useful info on Pipeline activities

#112. Azure Data Factory - Pipeline Pricing Info

#113. Call ADF1:Pipeline from ADF2:Pipeline using web activity

Run Python from ADF - Tips for Using Custom Activity

#115. Azure Data Factory - Exclude processed files from ADL

#116. Azure Data Factory - Troubleshooting guide

#117. Azure Data Factory - Get Max Row Number from a column in FILE

118. Azure Data Factory - Validate file names before Proceeding

#119. Azure Data Factory - Lookup activity to update

#120. Azure Data Factory - Fail Activity

#121. Azure Data Factory - Exclude header and footer from Excel file

Azure Data Factory - Move blobs to Cool\Archive\Delete tiers based on last modified date

Tips for Cracking an ADF Interview!

Azure Data Factory - FYI on Azure Data Analytics & U-SQL activity

Tips to Create Azure Free Subscription

Script Activity - New activity for DDL\DML in ADF and Synapse

Azure Data Factory - Run Powershell Script from ADF to delete folders\files in ADL

Azure Data Factory - Pass Parameters to Powershell Script from ADF

Azure Data Factory - Access Custom Activity Output from subsequent activities in ADF

Azure Data Factory - Use Powershell script to read BLOB metadata and change the tier to ARCHIVE

Azure Data Factory - Real time Scenario: Filter Hot\Cool tier files in BLOB ignoring Archive tier

Can I have a Career in ADF?

Azure Data Factory - FAQs-Quick Bites

Azure Data Factory - Select vs. Derived Column transformation - When to use when not to.

Azure Data Factory: Execute Python code importing custom modules

Azure Data Factory - Read from variable and write to a file in BLOB storage

Azure Data Factory - Partition a large table and create files in ADLS using copy activity

ADF: Different Files, Different Schemas, copy to different table (auto create on the fly)

Azure Data Factory - Cast Transformation

Azure Data Factory - Parse Complex Json in Data Flow activity

Azure Data Factory - Tips to name partitioned files as column data in data flow

Azure Data Factory - Parse JSON file using Copy Activity

ADF - Convert XML to .txt file using copy activity

Azure Data Factory - Use Filter activity to filter File names with Current Month -1, CurrentMonth -2

Azure Data Factory - Create files from column data using Copy activity

Azure Data Factory - Parallel foreach loop and Set variable issue explained

Azure Data Factory\ Synapse Analytics - Fail the pipeline if there is no file with today's date

Azure Data Factory - Split file into multiple files based on a Key column

Azure Data Factory\ Synapse Analytics - Replace special characters using data flow

Azure Data Factory\ Synapse - String to Date format

Azure Data Factory\Synapse Analytics - Use Case statement in Mapping Data flow

Azure Data Factory\ Synapse - Write If-elseif-else condition in derived column transformation

Azure Data Factory\Synapse - Copy Folders, Files from one ADLS container to another ADLS Container

Azure Data Factory\Synapse - Parameters vs. Variables - When to use what?

Azure Data Factory\Synapse Analyics - Escape Char & Quote Char Properies in Copy activity

Azure Data Factory\Synapse Analytics - Append filename in each row in all .csv files w/o using loop

Azure Data Factory\Synapse - Process multiple files in parallel using data flow

Copy Activity in Queued Status - Is it the same for all? Know why

Azure Data Factory\ Synapse Analytics - Find latest file in ADLS based on date on filename

Azure Data Factory\Synapse Analytics : Find latest file in ADLS based on date on filename

Azure Data Factory\Synapse Analytics - Check rowcount before doing copy from table

Azure Data Factory\Synapse Activity : Lookup data from a file with more than 5k records

Azure Data Factory\Synapse Analytics : Fail the pipeline if no files matching wild card pattern

Azure Data Factory - Use Azure SDK for Python to create Data Factory + Pipeline with a copy activity

Azure Data Factory - Create Data factory pipeline using Python

Azure Data Factory\Synapse: Compute sum of integer elements in array

Azure Data Factory : Use Web Activity to Call child pipeline & Pass Parent Run id via Body

Azure Data Factory : Use Web Activity to Call child pipeline & Pass Parent Run id via Body

ADF\Synapse Analytics - Pass dynamic value to filename in Sink in Copy Activity & Data flow

Azure Data Factory - Take first row\column from file

Scenario Based Question: Trigger exactly at 6am-8 am with two triggers

Azure Data Factory\Synapse: Decide name of additional column and its value dynamically

ADF\Synapse : Ignore XML with no records or Process XML that has records

ADF\Synapse: Validate Email ID using REGEX in data flow

ADF\Synapse: Store metadata of file in Az.Storage account

Pricing\ Costing Tips & Understanding - Detailed information on where you can cut down costs

Azure Data Factory\Synapse:Load from different XL files with different names to Az. SQL tables

ADF\Synapse - Copy files incrementally, based on Last modified date

ADF\Synapse - Use REST API to know pipeline run status

ADF\Synapse: Pass Pipleline Param to DataFlow Param and use it in Source query 2 filter Src data

ADF\Synapse: Interpret Script activity output json and write expressions to access column values

ADF\Synapse: Replace space in column names just like that, using Rule-based mapping

ADF\Synapse: Relialize the power of Wildcard based file copy!

ADF\ Synapse Analytics - Capture Metrics data from Data flow

Azure Data Factory\Synapse Analytics - Deep dive into Schema Drift

Find Latest Sub Folder in ADF\Synapse

Azure Data Factory \ Synapse Analytics - Delete folders older than 7 days!

Azure Data Factory\Synapse: Issues while Connecting to On-premise Server and fix for it

Azure Storage - Redundancy Options

ADF\Synapse: Simple technique to parse API JSON Response to load a SQL Table