wt is the difference between swith and filter stage
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 |
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)
hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(
What are the different kinds of views available in a datastage director?
parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?
how to sort two columns in single job in datastage.
How can we run same job in 1 day 2 times
file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks
how to call sequential generator in datastage?
CHANGE CAPTURE
Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?
Differentiate between datastage and datastage tx?
How many types of stage?