NUll handling in transformer

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
gaurakhu
Participant
Posts: 4
Joined: Wed Oct 08, 2008 5:20 am

NUll handling in transformer

Post 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
GAURAV
mystuff
Premium Member
Premium Member
Posts: 200
Joined: Wed Apr 11, 2007 2:06 pm

Post by mystuff »

Use NullToEmpty Function at all three places. However, prefer to do all in stage variables, if not all, atleast the constraint derivation.
Post Reply