issue with difference stage

[mallireddibalaji]

hi


Our requirement is first time we will get information from source we will
insert all the data(for 1st time)

from 2nd time onwards we need to identify the flags.
whether the record is new record or existing record and if any record not coming from the source and existing in target we need to delete that record.

we designed the job with difference stage
here we are using source as before link .
and we have used all the drop options as false

By using diff codes like diff_code=1(insert),diff_code=0(delete)
diff_code=3(edit),diff_code=2(copy)... we filtered out the data.

while checking the data in delete dataset with diff_code=0.
we are getting null's on key columns.

due to this issue we are unable to delete data.



could you please help me on this......?

[ray.wurlod]

It is more usual to use the target as the "before" input, because that's what's there before you attempt to apply the new data from source.

Add a Peek stage immediately after the Difference stage to determine precisely what the Difference stage is reporting.