We have moved to www.dataGenX.net, Keep Learning with us.

Tuesday, February 03, 2015

Modify Stage - Handling NULLs

For handling the NULL value in columns we can use modify functions in DataStage instead of Transformer. Rather, I'll always prefer a transformer to avoid unnecessary effort which we put to setting up modify stage. But sometime to tune the job over performance we have to do that ;-)

The below Function Specification we have to use to Handle NULL --


Column Name -->   EmpId

EmpId = handle_null(EmpId,'')                            --- Replace with empty string
EmpId = handle_null(EmpId,' ')                           --- Replace with Single Space
EmpId = handle_null(EmpId,'EMPTY')                       --- Replace with 'EMPTY'


Like the Facebook Page & join Group
https://www.facebook.com/DataStage4you
https://www.facebook.com/groups/DataStage4you

https://twitter.com/datastage4you
https://groups.google.com/d/forum/datastage4you
For WHATSAPP group , drop a msg to 91-88-00-906098


No comments :

Post a Comment