Need to implement logic to exclude matched records.

[rajudx]

As per the requirement need to exclude matched records if any source employer value will match with reference table employer value.

i.e. source input
---------------
203040
302340
103040

Reference table
--------------
203040
302340


Output should be : 103040 and values which match with reference table those need to be skip.

Source input and reference table both located on two different database servers and we can implement above mentioned logic through lookup stage using reject option, but in job design already lookup is using for other purpose.

Please suggest to idea to implement logic based on above mentioned requirement.

[ray.wurlod]

Use another Lookup stage. It is permissible to have more than one.

Or set the Lookup "failed lookup" rule to Continue and filter for null valued column downstream of the Lookup stage.