Page 1 of 1

NUll handling in transformer

Posted: Sat Jan 03, 2009 3:03 am
by gaurakhu
In my job I am using one column in stage variable ,constraint and to derive new column in transformer .I have to handle null three places

Posted: Sat Jan 03, 2009 8:51 am
by mystuff
Use NullToEmpty Function at all three places. However, prefer to do all in stage variables, if not all, atleast the constraint derivation.