what is the diff b/w switch and filter stage in datastage
- 2 Answers
- 15522 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 are the various kinds of the hash file?
Explain connectivity between datastage with datasources?
How to read the length of word in unix?
What is a merge?
I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know
what is the difference between the active datawarehouse and datawarehouse
how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project
Describe link sort?
Define ds designer?
which cache supports connected & un connected Lookup
What are the types of jobs we have in datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Teradata 
