question

VijaySahu-7884 avatar image
0 Votes"
VijaySahu-7884 asked ShaikMaheer-MSFT commented

ADF Pipeline - One to one table load

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

azure-data-factoryazure-synapse-analytics
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @VijaySahu-7884 ,

Just checking in to see if the below answer helped. If this answers your query, do click 130616-image.png and upvote 130671-image.png for the same. And, if you have any further query do let us know.

0 Votes 0 ·

1 Answer

NandanHegde-7720 avatar image
0 Votes"
NandanHegde-7720 answered

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/

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.