Interested to Buy Any Domain ? << Click Here >> for more details...
how can u handle null values in transformer stage.
- 7 Answers
- 27940 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prabhath.p
by using 1).Null to value(input column)
2.null to empty(input column)
3.if is null(input column_then
three commands are there in transformers for null handling
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / subhash
in tranformer we have one function like null handling so using the fuction options we can handel null vales in the table
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / rajeshchunduri
in transformer we have null handling functions in that by
using null to zero we can handle null.
chunduri
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / prasad
take one stage variable
sV: if (IsNull(colum_name) or Column_name='') Then 0 Else 1
and in constraint use
sV=0 (null records will goes to one target)(we can handle null by using stage variable)
sV=1 (not null records will goes to another target)
Plz Correct me, if am wrong......
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Answer / 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 |
HOW CAN WE SEE THE DATA IN DATASET?
What is the difference between the local container and shared container?
why we use parameters instead of hard code in datastage
project Steps,hits, Project level HArd things,Solved methods?
Define oconv () and iconv () functions in datastage?
hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz
What are stage variables, derivations and constants?
how to remove duplicates in transformer stage by using stage variables?one example?
How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?
how to find out number of records imported into source file?
Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x
I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com
Teradata 
