DSXchange

Hi,
I am working on CDC process to capture new,modified,unchanged and delete records.I was wondering if there is any difference between performing CDC process i.e capturing new,modified,unchanged and delete records before loading the data into table ,and after loading the data into table and performing CDC process because I need to capture new,modified,unchanged and delete records into there respective sequential files as per the requirement.In Server edition v 7.5
Thanx in advance

Normally you will do any type of CDC before writing to the target, since you usually will overwrite your target data so doing CDC after the update is kind of like backing up your data after the disk format.

Performing CDC after loading will not fetch you any data. The CDC that you performed before loading will give you the 'After Chagne' data. And the same will be loaded. If you want to do another Change capture with the Loaded data with Input data, you ll get all the records as copy. Don't you.