If one want to achieve this by using one job only, they can use change capture stage. Where they can use before and after image of the record(s). with this, they can Identify inserts (new records), deletes (existing record in the target got deleted), updates or changes (changes made to record). We are using Datastage 7.5.1 A (PX jobs). This stage is available in this.
This change may be used with Change Apply stage also. I used Transform stage and did further. I am not sure about the performance of these stages. Help available in datastage for these stages.
This stage is not available in server jobs.
Thanks,
Pavan Batchu
Replace existing rows
Moderators: chulett, rschirm, roy