Page 1 of 1

how to pass Null to default value wit out using transformer

Posted: Tue Apr 24, 2012 4:11 am
by vsandu
HI ,
i have source with null values ,i want pass the insted of null values as a "NAP"not applicable how we can we perform this
would you please help out this ...

Posted: Tue Apr 24, 2012 4:30 am
by BI-RMA
Use the "handle_null" option of the Modify-Stage if You have to avoid using a transformer.

COLUMN = handle_null (COLUMN,'NAP')