how can u handle null values in transformer stage.
Answer Posted / sailaja
Hi,
For Null handling in transformer you can use the below function dependind on ur requirement
1. Nulltoempty
2. Nulltozero
3.Nulltovalue
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
what is flow of project?
What all are the different way to run a job?
Define Job control?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What are the different common services in datastage?
If you want to use the same piece of code in different jobs, how will you achieve it?
What are the benefits of datastage?
What are the different kinds of views available in a datastage director?
What is the purpose of pivot stage?
What is active and passive stage?
Define oconv () and iconv () functions in datastage?
Notification Activity
what is the use of skid in reporting?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS