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

For WHATSAPP group , drop a msg to 91-88-00-906098

No comments :

Post a Comment