I am looking for a good tutorial or Article on how to import incremental data ( delta Loads) new records from SQL Server on Prem to Azure Data lake Gen2 in cloud using Azure Data factory V2.
My tables have modified date and I want to use that date do delta imports daily using ADF v2 , right now I a importing whole table using copy activity on daily basis with foreach loop to copy all tables with one step, Any good videos tutorials on how to insert only new records during this COPY ACTIVITY with FOREACH loop/
Thanks