Hash Logic Help

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Apr 18, 2005 3:24 pm

Perform a lookup from Table2 and code your logic in a condition.

vinaymanchinila · Post by **vinaymanchinila** » Mon Apr 18, 2005 3:29 pm

Hi,
I have built a hash file of all the part numbers from table2 but what happens if the part_no from table1 doesnt match part_no from table2, then I need to populate the field with 999 else with part_no.
Thanks

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Apr 18, 2005 3:30 pm

Check for any properties to be null or not found.

vinaymanchinila · Post by **vinaymanchinila** » Mon Apr 18, 2005 3:36 pm

My question is, can I populate the column even if there is no match in the hash file. If so how do I capture the value.

ray.wurlod · Post by **ray.wurlod** » Mon Apr 18, 2005 6:14 pm

If there's no match to the hashed file, then all columns returned from the reference input link are set to NULL by DataStage. You can capture the NULL by direct reference to the input link; otherwise there's no value to capture, so you might (for example) set a default value (999) in the output column derivation expression.

vinaymanchinila · Post by **vinaymanchinila** » Tue Apr 19, 2005 5:41 am

Thanks Ray, it makes sense now.