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


Please Help Members By Posting Answers For Below Questions

what is flow of project?

1771


What all are the different way to run a job?

865


Define Job control?

866


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?

2340


Difference between ‘validated ok’ and ‘compiled’ in data stage?

950


What are the different common services in datastage?

1005


If you want to use the same piece of code in different jobs, how will you achieve it?

919


What are the benefits of datastage?

968


What are the different kinds of views available in a datastage director?

819


What is the purpose of pivot stage?

870


What is active and passive stage?

1178


Define oconv () and iconv () functions in datastage?

1142


Notification Activity

1196


what is the use of skid in reporting?

2159


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

3544