Interested to Buy Any Domain ? << Click Here >> for more details...
what is the diff b/w switch and filter stage in datastage
- 2 Answers
- 16656 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are transforms and what is the differenece between routines and transforms?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
What is the method of removing duplicates, without the remove duplicate stage?
Describe link sort?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is difference between symmetric multiprocessing and massive parallel processing?
why do u need the IOS upgradation in a FC switch
how to abort the job its matain duplicates?
Differentiate between odbc and drs stage?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is a merge?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What are the steps needed to create a simple basic datastage job?
Define meta stage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
