Interested to Buy Any Domain ? << Click Here >> for more details...
how can u handle null values in transformer stage.
- 7 Answers
- 28211 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 you Implemented SCD Type 1 & Type 2 in your project?
What are the components of datastage?
How to manage date conversion in Datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
What is the importance of the exception activity in datastage?
How can we improve performance of data stage jobs?
How do y read Sequential file from job control?
client know skid info?
Name the command line functions to import and export the DS jobs?
What is aggtorec restructure operator?
What is orabulk stage?
What are orabulk and bcp stages?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Why do we use exception activity in Datastage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
