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