Interested to Buy Any Domain ? << Click Here >> for more details...
how can u handle null values in transformer stage.
- 7 Answers
- 27885 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 |
whats difference between ls -ltr and ls -lrt?
What is the difference between passive stage and active stage?
I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?
1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project
how can we send even and odd records from a sequential file to two different targets
10 Answers IBM, iGate, TCS,
Difference between JOIN,LOOKUP,MERGE?
which is more expensive hash or modulus partitioning? when do you use modulus partitioning?
How do y read Sequential file from job control?
Define ds designer?
Where the datastage stored his repository?
Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?
8 Answers Cognizant, HCL, TIAA CREF,
Hi Vijay here For Four CPU's how many nodes will required?
Teradata 
