Azure Data Engineer Interview Questions and Answers | adf real time interview questions | part 14

#Azure #AzureDataFactory #ADF #adfinterviewquestionandanswer
azure data factory interview question and answers.
In this video, I discussed about how to load data from multiple excel sheets to sql table using azure data factory:

get metadata activity in azure data factory | get metadata activity in adf | adf tutorial part 30:

foreach activity in azure data factory | foreach activity in adf | adf tutorial part 32:

copy data activity in azure data factory | Azure Data Factory Tutorial | ADF tutorial part 7:

adf interview question and answer:

adf tutorial:

[amritasingh]

Nice video,

In one of my recent interview there is one question,
How to load folder names and total file counts into that folder using adf pipeline.

[dhrubajyotichatterjee]

Nice explanation do you have any training classes

[sravankumar]

If we have a multiple excel files with sheets how should we do ?

[satishkumar-boue]

here y u using config.csv file, u already have excel file, this file included 3 sheets, .... y u use config.csv file in lookup activity, in lookup activity y u not directly taken excel file