DSXchange

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,

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.

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.

You can use change capture stage.

Change capture is in Enterprise.

Why not re-create the Target table instead of deleting. You can use bulk loader to load the target again.

To find the records which are not in Source, you need to do a look, it can be either through Lookup Stage or Join stage as Arnd saind or recreate a table thorough a query INSERT INTO ....(SELECT ... FROM <target> IN(SELECT ... FROM <source>)) as suggested by Siva.

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..