DSXchange

All,

I have two lists from 2 oracle stages. I want to know how to find out what is in list 2 but not in one. Can you please let me know how to do that.

Thanks

You could have list 1 be a lookup and have the unmatched keys go to a reject link for processing.

Use a transformer stage accepting both sources as input with list 2 as primary input and list 1 as a reference lookup. Join on all fields, if you have a unique primary key you can just join on those fields for faster processing. Have a single output with a constraint of list1.NOTFOUND. This will output any rows from list 2 that were not found on list 1.

Outer join in user-defined SQL .....


Thanks,
Anupam

Where are the lists once you've retrieved them from Oracle? If you write the lists of keys into two files in the &SAVEDLISTS& directory (using Sequential File stage), then you can use the LIST.DIFF command to ascertain the difference.