Hi mate,
I'm not sure what you mean exactly, but here is my guess: you want to control or prevent the table changes.
For this check out - About CDC Control Tables or Creating a Control Table
In jobs that include a change data capture transformation, you can use a control table to prevent the update of target rows that were processed in an earlier run. When you run a job that uses a control table, the CDC transformation first finds in the source the most recent insert, update, or delete action for a given unique identifier (business key). The most recent source row is then compared to the prior actions that appear in the control table. If the unique identifiers match, and if the rest of the rows are identical, then the source row is a duplicate and it is not added to the target.
Keep me updated with anyother doubts.
Hope this helps.
