Incremental Load

bond88 · Post by **bond88** » Tue Dec 04, 2012 9:58 am

Hi,
I need to get the modified data from source. There is no timestamp at source but there is at target. I am comparing source and target's every column as key in Change Capture stage. But I am getting both previous and current values as two rows. I need only the latest one how can I achieve that?

Thanks,

ArndW · Post by **ArndW** » Tue Dec 04, 2012 11:15 am

The CDC Stage will give you the code for each of the two records to tell you which source it comes from and what the type of change is, using that you can decide which record to keep or to drop in a stage after the CDC.

bond88 · Post by **bond88** » Tue Dec 04, 2012 11:22 am

Thanks ArndW. I used filter stage to get the required row.