S4 TABLE MERGE

Rohit Kulkarni 686 Reputation points
2022-04-20T13:06:48.233+00:00

Hello Team,

We have implemented the S4 Tables data into sql server tables .As of now we are truncating the data in SQL server and we are doing full load data from S4 to SQL Server. At the later stage the data in S4 will increase in millions of records at that stage the loading of Full Data into SQL server will be time consuming. So is there any method we can get only latest data from S4 and load only latest data into SQL server Tables. So that we can reduce the time consuming of the pipeline running.

Please advise

RK

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,133 questions
{count} votes