CDC stage

[jreddy]

We are implementing SCd and for every modified record that comes in from source, we have to insert new record in target and update the existing record with end_effdt and flag.

Using the CDC stage that has both source data and existing target table data as inputs (in datasets), the output seems to show only the records of the modified/added/deleted records from source.. but i also need to know some column values from target, so i can identify the existing record that needs to be flagged as logically deleted while i insert the newly modified record..
How can this be achieved?
Thanks for your suggestions in advance..