change capture

[knowledge]

Hi ,

I want to find out the records which got deleted from source but still in the target , set the delete flag yes for those records.

I used change capture stage so I am getting the deleted records but all fields are null as I am getting data from source which is my after data set , there I dont have any value for those field since those are deleted from the source , so the o/p gives me just the count of deleted records but no useful data ,

pl suggest ,

Is there any other way we can do this ,

thanks ,

[ray.wurlod]

You MUST have access to the before Data Set - it's physically impossible to determine which rows have been deleted by inspecting the after Data Set.

[ameyvaidya]

A variation of something I'd suggested <a href="viewtopic.php?t=96347">before</a>:

Code: Select all

After--------
                |
                |
                ---->CDC--------
                |      (Delete) |
Before-----> Copy------------->Join---

with the same disclaimer:
It sucks and destroys all performance.

Also another (either that or I am daydreaming):
I have not tested this but can't the inputs be flipped around (before becomes after and after becomes before) and the change capture stage stage be set to check for Inserts