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
How a routine is called in datastage job?
How do you register plug-ins?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
What are the enhancements made in datastage 7.5 compare with 7.0?
What are the partitioning techniques available in link partitioner?
What are the different plug-ins stages used in your projects?
State the difference between an operational datastage and a data warehouse?
How do you start developing a datastage project?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
How do you remove duplicate values in datastage?
How one source columns or rows to be loaded in to two different tables?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
what is the custome stage in datastage? how can we impliment that one? plz tell me
How many types of sorting methods are available in datastage?
How to find value from a column in a dataset?