DSXchange

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.

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.

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

Yes, it means precisely that.

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

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