Hi @Kapil Ganweer ,
Welcome to Microsoft Q&A Platform. Thank you for posting your query here.
You need to use Lookup activities and Copy Activities with some watermark columns to achieve the same.
Below documentation explains incremental data copy in case of sql tables. Kindly follow same approach to accomplish your need.
https://learn.microsoft.com/en-us/azure/data-factory/tutorial-incremental-copy-portal
To know more above service now connector in Azure data factory Click here.
Hope this will help. Thank you.
-------------------------------
- Please
accept an answer
if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how. - Want a reminder to come back and check responses? Here is how to subscribe to a notification.
Hi @Kapil Ganweer ,
Just checking is below provided answer helps you? If yes, Please
Accept Answer
. Accepting answer will help community too. Thank you.