# 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)
```

<figure><img src="https://1682448182-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO8vUiMZbKjefXbyOes%2Fuploads%2F8cyRKhaDii71kFD0k2pF%2Fimage.png?alt=media&#x26;token=85947f7a-72f7-44c1-873f-be4767ce51ff" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://1682448182-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO8vUiMZbKjefXbyOes%2Fuploads%2FGKYsf1YF6b2ImuYcBRKE%2Fimage.png?alt=media&#x26;token=435bdb21-332c-4af3-94e1-9651098a1d0b" alt=""><figcaption></figcaption></figure>

&#x20;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.&#x20;

<figure><img src="https://1682448182-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MO8vUiMZbKjefXbyOes%2Fuploads%2FZ5N5XLZq7gcHK5r7AQ6v%2Fimage.png?alt=media&#x26;token=7d2f9e74-a570-4d38-abdf-3f22760095a1" alt=""><figcaption></figcaption></figure>
