what is the diff b/w switch and filter stage in datastage
- 2 Answers
- 15467 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 |
How a source file is populated?
What is merge stage?
how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?
in source is like seq file in date column have dd-mm-yy dddd-mmmm-yyyy mm-dd-yy yy-dd-mm yy-mm-dd i want to display only yy-dd-mm date formats only in tgt?
in oracle target stage when we use load option and when we use upsert option?
What is diff between Junk dimensions and conform dimension?
I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?
What is the difference between informatica and datastage?
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?
What is ibm datastage flow designer?
What are stage variables and constants?
I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on
Teradata 
