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
What is the difference between account and directory options ?
Explain ibm infosphere information server and highlight its main features?
How to perform incremental load in datastage?
Name the different types of Lookups in Datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
How do you run datastage job from the command line?
What are the different types of lookups in datastage?
What are routines in datastage? Enlist various types of routines.
What are the partitioning techniques available in link partitioner?
Define APT_CONFIG in Datastage?
What all are the different way to run a job?
which r the connectors used in san?
What are the types of containers in datastage?
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...
whom do you report?