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......?
issue with difference stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 24
- Joined: Wed Mar 19, 2008 1:13 am
issue with difference stage
M.BALAJI
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Add a Peek stage immediately after the Difference stage to determine precisely what the Difference stage is reporting.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.