how can u handle null values in transformer stage.
- 7 Answers
- 26670 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
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Describe stream connector?
Define repository tables in datastage?
Enlist various types of routines in datastage.
How can we improve performance of data stage jobs?
Define ds designer?
What are the different layers in the information server architecture?
How and where you used hash file?
What is the flow of loading data into fact & dimensional tables?
How we can covert server job to a parallel job?
Triggers,VIEW,Procedures
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
How many types of stage?
Difference between server jobs & parallel jobs?
Can we use target hash file as a lookup ?
