lookup reject due to reference

atul9806 · Post by **atul9806** » Tue Jun 30, 2015 9:45 pm

Hi team
We are using lookup stage with 2 reference data (both are quite small) and collecting reject, now we want to enhance this job by adding the logic to get due to which reference data the main data got rejected, currently I am doing that in transformer. I am curious if we can do that in lookup itself. Please share your thoughts.

ray.wurlod · Post by **ray.wurlod** » Tue Jun 30, 2015 11:34 pm

Yes, but only by using two Lookup stages with Reject links, and mechanisms on each of those (e.g. Column Generator stage) to add the description of which lookup it was rejected by.

atul9806 · Post by **atul9806** » Thu Jul 02, 2015 12:10 am

Thanks Ray, Yes we can do that by using two lookup stage, which generate two reject.
So this mean we can not do that in single lookup stage, any other thoughts guys

ray.wurlod · Post by **ray.wurlod** » Thu Jul 02, 2015 2:23 am

Yes, it means precisely that.

No other thoughts - this is a binary choice and the other alternative is not possible.

atul9806 · Post by **atul9806** » Thu Jul 02, 2015 11:55 am

Thanks Ray for your comment. I am closing this thread now.