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
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Define oconv () and iconv () functions in datastage?
What is the difference between datastage and informatica?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Notification Activity
What are the main features of datastage?
Explain ibm infosphere information server and highlight its main features?
How do you run datastage job from the command line?
What is datastage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
how to write server Routine coding?
How can you write parallel routines in datastage PX?
what are the devoleper roles in real time? plz tell i am new to datastage....
What is the difference between hashfile and sequential file?
How many Key we can define in remove duplicate stage?