Interested to Buy Any Domain ? << Click Here >> for more details...
how can u handle null values in transformer stage.
- 7 Answers
- 28209 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 |
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?
What are the steps needed to create a simple basic datastage job?
What are the different database update actions available?
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?
On which Dimension Table you implemented SCD Type in your Project
what is the use of surogate key in datastage
What are the various kinds of containers available in datastage?
what r the sources u need to create the datastage?
Teradata 
