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.
lookup reject due to reference
Moderators: chulett, rschirm, roy
lookup reject due to reference
Last edited by atul9806 on Thu Jul 02, 2015 12:10 am, edited 1 time in total.
~Atul Singh
<a href=http://www.datagenx.net>DataGenX</a> | <a href=https://www.linkedin.com/in/atulsinghds>LinkedIn</a>
<a href=http://www.datagenx.net>DataGenX</a> | <a href=https://www.linkedin.com/in/atulsinghds>LinkedIn</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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
So this mean we can not do that in single lookup stage, any other thoughts guys
~Atul Singh
<a href=http://www.datagenx.net>DataGenX</a> | <a href=https://www.linkedin.com/in/atulsinghds>LinkedIn</a>
<a href=http://www.datagenx.net>DataGenX</a> | <a href=https://www.linkedin.com/in/atulsinghds>LinkedIn</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Thanks Ray for your comment. I am closing this thread now.
~Atul Singh
<a href=http://www.datagenx.net>DataGenX</a> | <a href=https://www.linkedin.com/in/atulsinghds>LinkedIn</a>
<a href=http://www.datagenx.net>DataGenX</a> | <a href=https://www.linkedin.com/in/atulsinghds>LinkedIn</a>