Lookup condition not found

vilasini · Post by **vilasini** » Wed Dec 26, 2007 11:28 pm

Hi Friends,

I have a job in which if the lookup condition found ,field name sould map to the output else set Null to the output.Can we specify in lookup like the contion not found? to set it null.
Plz help me out on this.

Regards
Vilasini

ray.wurlod · Post by **ray.wurlod** » Wed Dec 26, 2007 11:47 pm

I am assuming you are using a Lookup stage. Simply change the Lookup Failed rule to "Continue" and make sure that every output column derived from the reference input link is defined to be Nullable and/or has a default value set. The former, if you explicitly want NULL.