Hi All
We have requirement to load the Teradata tables data in Azure Synapse which is one to one mapping load. We have more than 200 tables in TeraData and we don't create 200 different pipeline. We are required to create one pipeline which will read 200 tables one by one and load in Synapse table... It is One to One mapping load.
Kindly please suggest how can we achieve this
Hi @VijaySahu-7884 ,
Just checking in to see if the below answer helped. If this answers your query, do click 
and upvote 
for the same. And, if you have any further query do let us know.
Hey,
You need to create a lookup table that would contain the list of all the tables that you want to copy and then iterate it over loop for copying the data sequentially.
The below links would explain it in detail:
https://analytics-blog.com/2019/09/24/copy-multiple-tables-in-azure-data-factory/
https://key2consulting.com/how-to-copy-multiple-tables-from-on-premise-to-cloud-in-azure-data-factory/
17 people are following this question.
