Interested to Buy Any Domain ? << Click Here >> for more details...
how can u handle null values in transformer stage.
- 7 Answers
- 27682 Views
- I also Faced
- E-Mail Answers
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
How many Key we can define in remove duplicate stage?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
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?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Can we use target hash file as a lookup ?
Name the different sorting methods in datastage.
Which algorithm you used for your hashfile?
What are sequencers?
What is size of a transaction and an array means in a datastage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What is usage analysis in datastage?
Difference between data warehousing and olap?
Have you have ever worked in unix environment and why it is useful in datastage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
