wt is the difference between swith and filter stage
- 6 Answers
- 17205 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 |
i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?
Explain entity, attribute and relationship in datastage?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari
how can u connect the client system directly at any time?
What is the difference between in process and inter process?
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)
HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS 'VIJAY'?
What is RCP
why do we need a datawarehouse when we have databases to store data?
what is materialized view used datastage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Teradata 
