what is the diff b/w switch and filter stage in datastage
- 2 Answers
- 15512 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / uday
filter:1)we can write the multiple conditions on multiple
fields
2)it supports one inputlink and n number of outputlinks
Switch:1)multiple conditions on a single field(column)
2)it supports one inputlink and 128 output links
| Is This Answer Correct ? | 20 Yes | 0 No |
Answer / prasad
and also filter supports like =,>,<,<>,>=,<=,and,or,not operators
switch stage supports only one equal(=) operator.
| Is This Answer Correct ? | 2 Yes | 0 No |
What could be a data source system?
What all the types of jobs you developed?
Which commands are used to import and export the datastage jobs?
What is the use of Row generator stage?
how can find maximum salary by using Remove duplicate stage?
With out using Funnel Stage, how to populate the data from different sources to single target
What are the functionalities of link collector?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Can aggregator and transformer stages use to sort the data? How ?
Is there any possibility to generate alphanumeric surrogate key?
How many areas for files does datastage have?
What is the default execution order of the sequential file?
Teradata 
