Data_Destination_Container is the root path of the place where the data is copied to in your destination store.The type of this column is typically datetime, INT, or similar. Data_Source_WaterMarkColumn is the name of the column in the source table that's used to identify new or updated rows.Data_Source_Table_Name is the table in the source database that you want to load data from.The template defines following parameters: SqlServerStoredProcedure writes the current high-watermark value to an external control table for delta copy next time.The query that identifies the changes in the source database is similar to 'SELECT * FROM Data_Source_Table WHERE TIMESTAMP_Column > “last high-watermark” and TIMESTAMP_Column <= “current high-watermark”'. Copy copies only changes from the source database to the destination store.Another Lookup activity retrieves the current high-watermark value from the source database.Lookup retrieves the old high-watermark value, which is stored in an external control table.Finally, it stores the new high-watermark value to an external control table for delta data loading next time.
![factory reset delta hmi factory reset delta hmi](https://img1.exportersindia.com/product_images/bc-full/dir_156/4679592/allen-bradley-scada-software-1501050727-3173273.jpeg)
![factory reset delta hmi factory reset delta hmi](https://i.ytimg.com/vi/2Hrik-ghWoU/maxresdefault.jpg)
After that, it copies only the changes from the source database, based on a comparison between the two watermark values. This template first retrieves the old watermark value and compares it with the current watermark value. That tool uses a trigger-scheduled time as a variable to read new rows from the source database. If you have a timestamp column in your source database to identify new or updated rows but you don't want to create an external control table to use for delta copy, you can instead use the Azure Data Factory Copy Data tool to get a pipeline.