adf realtime project interview question and answer | Azure Data Engineer Interview Question & Answer

#Azure #AzureDataFactory #ADF #adfinterviewquestionandanswer
azure data factory interview question and answers.
In this video, I discussed about how to load data from multiple excel files, multiple excel sheets to multiple SQL table using azure data factory:
execute pipeline activity in azure data factory | execute pipeline activity in adf | adf part 40:
• execute pipeline activ...
Lookup Activity in Azure Data Factory | ADF tutorial part 26:
• Lookup Activity in Azu...
if condition activity in adf | If Condition Activity in Azure Data Factory | adf tutorial part 28:
• if condition activity ...
get metadata activity in azure data factory | get metadata activity in adf | adf tutorial part 30:
• get metadata activity ...
foreach activity in azure data factory | foreach activity in adf | adf tutorial part 32:
• foreach activity in az...
copy data activity in azure data factory | Azure Data Factory Tutorial | ADF tutorial part 7:
• copy data activity in ...
adf interview question and answer:
• pwc azure data enginee...
adf tutorial:
• Azure Data factory (adf)

[@goluSingh-su1xs]

Wow, superb video 👍

[@ssunitech6890]

Thanks 🙏

[@amritasingh1769]

Great explanation

[@ssunitech6890]

Thanks 🙏

[@JjCSJ]

Awesome

[@ssunitech6890]

Thanks

[@arjun-cv9rk]

Why can't we use lookup Activity in ForEachActivity

[@jangamlaxmangoud6194]

Please make a video on ,how to copy multiple tables from onprimses to blob ( fact tables to fact folder and dimension tables to dimension folder in blob ) and both dim n fact both in another separate folder

[@ssunitech6890]

This question is on my list will upload soon

[@jangamlaxmangoud6194]

@@ssunitech6890 Tq sir

[@sundipperumallapalli]

Sir Also Please Share the Input Container Files If Possible 🙂

[@ssunitech6890]

Files cannot be shared, 😔

[@zahidalam7831]

why did u use getmetadata activity

[@user-gb6sq4xg3e]

instead of adding another pipeline and invoking, why cant we add lookup inside first foreach and proceed?

[@2007mnkumar]

that is not possible. because it is passing filename through foreach loop then In Second Pipeline, it is getting sheet details for that particular file and perform the operation.

[@hamzax233]

Sir how to do the Same for CSV file types?? I have only CSV files and using non SQL storage like Copy from Blob To DataLake Gen2 storage, and I am unable to follow along. Please make separate video if possible.

[@ssunitech6890]

Sure will record one video on this soon

[@noothandairies]

Nice

[@ssunitech6890]

Thanks, Please share to others

[@satishkumar-bo9ue]

can u write here stored procedure syntax

[@saleman6133]

Anybody want Bigdata Hadoop Materials Realtime project