1.How do u handle NULL in sequential stage.
2.Difference between switch stage and filter stage.
Answers were Sorted based on User's Feedback
Answer / ashok
2.in switch stage we can write conditions on only one field
(column).but in filter we can write conditions on multiple
fields.
Is This Answer Correct ? | 10 Yes | 0 No |
Answer / xxx
in sequvential file,click on columns tab and click on left
side of column then we can provide null field value.
diff between switch and filter is ,switch is expression
based and filter is condition based
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sruthi
The main difference between switch and filter is switch supports only 128 output links where as filter stage can have any any number of output links
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / venkataramireddy
Switch:we can write the mutiple conditions on single
column , it suport one input and 128 outputs.
Filter: We can write multiple conditions on mutiple
columns, it supports one input and n outputs.
Is This Answer Correct ? | 1 Yes | 1 No |
How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?
how do you pass parameters in a script?
which cache supports connected & un connected Lookup
source contains 2 columns comes to target 4 columns how
What are some prerequisites for datastage?
How can we run same job in 1 day 2 times
Can you implement SCD2 using join, transformer and funnel stage?
i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?
iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..
I want capture UnMatched records from Primary source and secondary source in JOIN stage?
Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.
What is process model?