DSXchange

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

yes, we do not have CDC stage in server Jobs.
so i will go with Craig's idea and split into 2 jobs.

Making it two jobs will give you more modularization as well. As mentioned earlier, you can avoid the Aggregator to make it bit more efficient. If you focus is all about performance tuning.