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
CDC process
Moderators: chulett, rschirm, roy
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.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'