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 |
Differentiate between datastage and datastage tx?
What is the function in Transformer stage can act as Rank Function in oracle
What is the difference between the local container and shared container?
Differentiate between validated and Compiled in the Datastage?
which is more expensive hash or modulus partitioning? when do you use modulus partitioning?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What all are the different way to run a job?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Why we use parameters instead of hard code in datastage.
data stores in which location while using data set stage as the target?
can we use sequential file as a lookup
How to convert RGB Value to Hexadecimal values in datastage?