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

#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 multiple SQL table using azure data factory:

Lookup Activity in Azure Data Factory | ADF tutorial part 26:

if condition activity in adf | If Condition Activity in Azure Data Factory | adf tutorial part 28:

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:

[goluSingh-suxs]

Your questions and way of teaching is superb. 👍
Keep uploading videos on these.

[oggyboggy-zcnd]

Can we not take the table name dynamically from foreach? Whats the need to maintain a SQL table for tablename? Like the parameterized TableName, as used in the vid 13

[sravankumar]

If we have multiple excel files with multiple sheets then how can we load to multiple table's? Please explain this scenario

[venkatchinta]

TCS interview question

while moving the multiple files from blob to azure SQL how to give filenames to tables & how to replace the space with _ in file name in adf. because SQL tables don't allow spaces in names.

please do a video on this scenario & also

please create a scenario on cloud to onpremise.

from tcs they asked me about cloud to onpremise scenario