how can u handle null values in transformer stage.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between account and directory options ?

882


Explain ibm infosphere information server and highlight its main features?

848


How to perform incremental load in datastage?

911


Name the different types of Lookups in Datastage?

996


What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

1873


How do you run datastage job from the command line?

833


What are the different types of lookups in datastage?

835


What are routines in datastage? Enlist various types of routines.

862


What are the partitioning techniques available in link partitioner?

2034


Define APT_CONFIG in Datastage?

857


What all are the different way to run a job?

844


which r the connectors used in san?

1979


What are the types of containers in datastage?

935


Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

3956


whom do you report?

1723