Differnce between filter and router?
- 14 Answers
- 37648 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ashish a
first the Similarity between Router and Filter is
-Both transformation would able to discard data based on
some filter condition.
The Differences are...
1.Using router transformation one would able to test
incoming data for multiple filter condition and if none of
the condition met the incoming rows gets reouted to DAFAULT
group.
2.Using filter transformation one would able to pass data
to next transformation based on single filter pipeline
condition.There is no option of routing data that doesnt
match the condition like ROUTER Transformation.
| Is This Answer Correct ? | 38 Yes | 3 No |
Answer / xxx
filter: it drops the data that do not meet the condition
Router:it has an option to capture the data that do not
meet the condition
| Is This Answer Correct ? | 25 Yes | 2 No |
Answer / naresh araveti
the difference b/w filter and router is that fiter works on
single conditon & wherein router works with mulpile
condition & it also can poolup up discarded data..
| Is This Answer Correct ? | 23 Yes | 2 No |
Answer / thava
Filter =One condition
Router=More than one condition
When you have more than one condition to be checked we can
use more than one filter for each condition but it is time
consuming,so router is the best transformation to be used
there instead of multiple filter transformations.
| Is This Answer Correct ? | 16 Yes | 1 No |
Answer / hari
->filter allows single conditions where as router allows
multiple conditions
->filter connected to a single target where as router
concted to multiple targets
->filter do not capture the rejected records where as router
capture rejected records and store into the default out put
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / saradhi
Filter is like an where condition.
its having only one condition and its not having default
data.
In Router its having multiple condtions and its maintain
the default data also.
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / bhanu prakash
->filter transformation is used for only one condition
where as router transformation is used for multiple conditions
->in filter transformation there is only one target,where as
in router transformation there is more than one targets.
-> filter is like where condition in SQL
router transformation is like SUB Query in SQL
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / jang
If we what to test for multiple conditons, then we need to
have multiple Filters TRN's, so each filter TRN scans the
data. Where as in Router TRN data is only once scan or read
to evaluate the conditions, so the performance may be good
with router.
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / srinivas
1.Filter will removes unwanted data based on a filter
condition,if we want use multiple filter conditions using
filter it is not possible,so we have another option i.e router.
2.Router:advantage is one input can be passed and based
on filter conditions output will be get,here matched
condition and un-matched condition records can be get
| Is This Answer Correct ? | 4 Yes | 1 No |
What is a sequence generator transformation?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
why do we go for update strategy tr in SCD rather using the session properties?
Mention some types of transformation?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is depict expression change?
how do u tune queries?
What is a standalone command task?
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Teradata 
