how can u handle null values in transformer stage.
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 |
when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....
How to remove duplicates in transformer stage? in parallel mode
Explain datastage architecture?
how to delete one row in target dataset
How to implement complex jobs in data stage?
how to capture rejected data by using join stage not for lookup stage. please let me know
What are the types of containers in datastage?
EXPLAIN SCD
how can we send even and odd records from a sequential file to two different targets
10 Answers IBM, iGate, TCS,
How to transfer file from one system to another system in UNIX?which command to be use?
how do you pass parameters in a script?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2