In which Database Write Strategy do we use a CDC file?¶
We use a CDC Hash file in the Source Diff Processor, whereas the Database Diff Processor relies on source CDC. However, the CDC file used in Source Diff Processor is different than usual. Instead of incrementing the records based on time, it captures a snapshot of the entire dataset and then compares whether the records have been inserted, updated, deleted, or skipped.