1.How do u handle NULL in sequential stage.
2.Difference between switch stage and filter stage.
- 4 Answers
- 9569 Views
- I also Faced
- E-Mail Answers
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 |
Enlist various types of routines in datastage.
I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?
If you want to use the same piece of code in different jobs, how will you achieve it?
hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
How many Key we can define in remove duplicate stage?
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
Why do we use link partitioner and link collector in datastage?
what is the diff between sequential file and fileset stages?
Tell me the syntax of Configuration file?
What are the areas of application?
How can we select pr retrieve the particular row in dataset by using orchadmin command?
What is the project in datastage?
Teradata 
