capture lookup failure

vishu19aug · Post by **vishu19aug** » Thu Mar 01, 2012 4:34 pm

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

SURA · Post by **SURA** » Thu Mar 01, 2012 4:48 pm

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

ray.wurlod · Post by **ray.wurlod** » Thu Mar 01, 2012 5:59 pm

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.

DSXchange

capture lookup failure

capture lookup failure

Re: capture lookup failure