lookup input variable NOTFOUND not working

[HariK]

Hi,

The job description is as follows

Source -- DRS for SQL server
Reference -- DRS for SQL server
Transformer -- performing lookup operation
Target -- DRS for SQL server

I am using lookup input link variable NOTFOUND(=0) in transformer constraint to segregate records which has a match from which doesn't have a match.

The issue is all the records including which does not have match are passed to output link for matched records.

I tried using the ISnull function in the constraint and it is working fine.

Trying to find out if there is any other soultion or workaround for the NOTFOUND variable issue.

[chulett]

The NOTFOUND link variable only works reliably with a hashed file lookup. For direct database lookups, you need to fall back to the Old Skool null check as you are doing.