how can u handle null values in transformer stage.
Answer Posted / subhash
null handling in transformer in two ways
one for
1. identifing the Null values
2. Remove the Null values
1.Ans: by using Null handing function
2.Ans: By using Constrains we can Remove the Null Values Rows
In transformer
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
How many types of sorting methods are available in datastage?
Notification Activity
What are the job parameters?
Is possible to create skid in dim,fact tables?
How to read multiple files using a single datastage job if files have the same metadata?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What can we do with datastage director?
What is the roundrobin collector?
how to export or import the jobs in .ISX file
Explain the importance of surrogate key in data warehousing?
Where do the datastage jobs get stored?
What all the types of jobs you developed?
Can you filter data in hashed file?