Hi,
I have an input with a key and another table with error records. I have to match my input with the table and get only the non matching records. Currently I have a lookup, output and reject. But, since I don't want any matched records for further processing, I want to avoid writing these matched recors into a file. Is there any way I can capture only the Non Matching records from look up?
Input 1: File
Lookup: Table
Output: Only non matched records
Thanks in advance,
Yugee.
Capture Only Not matching rows
Moderators: chulett, rschirm, roy
Thanks Craig..But in my case there are 90% records matching and only 10% of them are not matching (average volume in the input is around 100K). I can have a filter stage to get only the null value records, but in this case I will be checked the null value for an extrat 90% of the records. This job is critical and any time/processing saved would be critical.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Use a Reject link on the Lookup stage to capture the failed lookups.
Direct the regular output link to a sink of some kind, such as a Copy stage with no output link.
Direct the regular output link to a sink of some kind, such as a Copy stage with no output link.
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.