Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

whats difference between ls -ltr and ls -lrt?

5 Answers   L&T,


What is the difference between passive stage and active stage?

0 Answers  


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?

7 Answers   CTS,


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

1 Answers   Accenture,


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?

2 Answers   CTS,


which is more expensive hash or modulus partitioning? when do you use modulus partitioning?

2 Answers   TIAA CREF,


How do y read Sequential file from job control?

2 Answers   HP, IBM, Telesis,


Define ds designer?

0 Answers  


Where the datastage stored his repository?

0 Answers  


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?

4 Answers   TCS,


Categories