Interested to Buy Any Domain ? << Click Here >> for more details...
wt is the difference between swith and filter stage
- 6 Answers
- 19353 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kiran
Hai Swamy..,
How are You?
Your Ans is wrong boss.
In filter Stage we can give multiple conditions on
multiple columns,But every time data come from source
system and filtered data loads into target .where as in
switch stage we can give Multiple conditions on Single
column,but data come only once from the source and checks
all the conditions in the switch stage and loads in to
target.
Please correct ur ans.
Thank u
| Is This Answer Correct ? | 27 Yes | 2 No |
Answer / murari
swithch consists of 1 i/p link,128 output links and one reject link.
Filter consistd of 1 i/p link, n no.. of output links and one reject link..
we can perform on single colum in switch but in filter we can perform on multiple columns..
| Is This Answer Correct ? | 16 Yes | 0 No |
Filter: It contains 1 input link and multiple output links
we can write the multiple conditions on the multiple
fields.
switch: It contains 1 input link and 128 output links
we can write the multiple conditions on a single
field
- Nannesaheb(+918807423181)
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / nish
Apart from aforementioned answers
Switch is viable when u have less number of values to branch out.
Filter is versatile and you can use UNIX commands/sed also in filter condition.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / balaji
Filter stage:
Multiple conditions means <,>,=,<=,>=
Takes one input link and gives one or more output links and
one reject link
Switch stage:
Only Equal operator
Takes one input link and gives one output link
| Is This Answer Correct ? | 2 Yes | 6 No |
Answer / swamy
Hi,
The main diff between filter and switch stages..
filter performs on sql queries and we can declare 'n' num
of out puts for 'n' num of where clause conditions.
But in swith stage perfoms on single column level rows
only.. and every time it checks source system befor going
to load the data into target, but filter not like that.
If you have any doubt in this.... give a cal to my num..
Swamy - 9985223203
| Is This Answer Correct ? | 0 Yes | 12 No |
In my previous project we get data from mainframe and load it into datastage DB2 tables.Sometimes we get data as flat file or a mainframe tables itself directly we fetch the data.Is this a migration project?
Wat is isolation level and when do u use them?
Why do we use link partitioner and link collector in datastage?
types of errors in datastage?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
what is the unix script to run the job? Please mention commands which we use often?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
how to find diff between 2 dates without using Icon... funtions?
Define Job control?
What are the functionalities of link partitioner?
What is the difference between server job and parallel jobs?
SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?
Teradata 
