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,
Incremental Load
Moderators: chulett, rschirm, roy
Incremental Load
Bhanu
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>