Rejecting records in Lookup stage

sweety123 · Post by **sweety123** » Fri Jan 29, 2010 1:17 am

Hi all,

I need to reject records to a sequential file when the lookup fails. Can anyone guide me how to do this.....?

ray.wurlod · Post by **ray.wurlod** » Fri Jan 29, 2010 1:24 am

Create a reject link on the Lookup stage and feed it into a Sequential File stage. Change the Lookup Failed rule in the Lookup stage so as to direct stream input rows for which the lookup failed to the reject-handling link.

sweety123 · Post by **sweety123** » Fri Jan 29, 2010 1:34 am

I did just that.....but the lookup stage is not showing the reject file......

ray.wurlod · Post by **ray.wurlod** » Fri Jan 29, 2010 4:21 am

It can't not show it.

Does your Lookup stage have two (or more) input links and two output links? What do the output links look like?