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 ?
Can you explain how could anyone drop the index before loading the data in target in datastage?
How many types of stage?
what is flow of project?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What are the various kinds of containers available in datastage?
What is data partitioning?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What are the repository tables in datastage?
What are datastage sequences?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Name the command line functions to import and export the DS jobs?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What are the different plug-ins stages used in your projects?