DSXchange

Hi Enterprise doesn't seem to use Oconv etc for Timestamp conversions. Would be grateful if anyone can give me any ideas regarding converting timestamps from DB2 source to Oracle Target. I can't get the transformer to compile at all if I try doing just a straight -through copy. Error says "Erro...

Hi All,

Thanks for all the suggestions, we have had to redesign all the maps to run in Enterprise, so we'll be using the Change Capture stage to deal with the deletes.

Cheers..

ArndW wrote:Sure you can, it is quite easy. One easy way (but not necessarily the fastest for huge data volumes): Do a lookup from the target to the source; if the lookup is not successful then output to a stage which deletes those rows from the target.

Thanks for this... Will try this out.

Hi,

Is there any way in which rows which no longer exist in the Source tables can be deleted from the target tables using logic inherent to Datastage?

We are running server jobs on the Datastage Enterprise 7.5.1.A edition.

Thanks,