how can u handle null values in transformer stage.

Answers were Sorted based on User's Feedback



how can u handle null values in transformer stage...

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

how can u handle null values in transformer stage...

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

how can u handle null values in transformer stage...

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

how can u handle null values in transformer stage...

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

how can u handle null values in transformer stage...

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

how can u handle null values in transformer stage...

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 u handle null values in transformer stage...

Answer / naresh

Depending on the client requirement we can handle the nulls
by using null handling functions..we need to handle nulls if
the column null type is no only ..

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More Data Stage Interview Questions

why we use parameters instead of hard code in datastage

4 Answers   HCL,


Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .

2 Answers  


How to remove blank spaces from data?

3 Answers  


What are system variables and sequencers in datastage

0 Answers  


Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?

8 Answers   Semantic Space,






is it possible to access the same job by two users at a time in DataStage?

2 Answers   IBM,


I have a few records all are same structures data, I want to store data in multiple targets how?

4 Answers   Polaris,


there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why

1 Answers   Virtusa,


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

0 Answers  


How can u write exception handling in seq file????

2 Answers   IBM,


Lookup constraints

0 Answers   CTS,


Define oconv () and iconv () functions in datastage?

0 Answers  


Categories