DSXchange

Hi,

I need to implement the 'Not Exists' logic of SQL in Datastage. How can i capture lookup failure records in a file or is there a way to do this in Join stage.

Thanks,
vishal

Can't you use reject in LKUP and get it in a file?

If it is in join, use full outer and in the following TFM do the condition in Stage variable and filter it.

DS User

Capture failed lookups using the Failed Lookup rule; direct these to a rejects file from the Lookup stage. Successful lookups can be directed to a Copy stage with no output if you prefer to discard these.