Incremental Change Tracking

To enable change tracking on a specific table, you can issue the following command, through the sql browser using the SqlSource connection:

// 
ALTER TABLE [enter table name]
ENABLE CHANGE_TRACKING
WITH (TRACK_COLUMNS_UPDATED = ON)

In order to use change tracking on a mapping you will need to set the Load Type to Incremental Change Tracking.

Kodda will then add a new column to the table named “si_change_type_cd” this column will indicate the type of change that was last applied to that record (I = Insert, U = Update, D = Delete).

If you would like to permanently delete the records that have been removed from the source, you can do this by enabling the ‘Remove Deleted Records’ option.