Page 1 of 1
Posted: Mon Apr 18, 2005 3:24 pm
by Sainath.Srinivasan
Perform a lookup from Table2 and code your logic in a condition.
Posted: Mon Apr 18, 2005 3:29 pm
by vinaymanchinila
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
Posted: Mon Apr 18, 2005 3:30 pm
by Sainath.Srinivasan
Check for any properties to be null or not found.
Posted: Mon Apr 18, 2005 3:36 pm
by vinaymanchinila
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.
Posted: Mon Apr 18, 2005 6:14 pm
by ray.wurlod
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.
Posted: Tue Apr 19, 2005 5:41 am
by vinaymanchinila
Thanks Ray, it makes sense now.