Interested to Buy Any Domain ? << Click Here >> for more details...
Differnce between filter and router?
- 14 Answers
- 41379 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ibrar ahmad
1). In filter we can give condition that has to be satisfy
else rows will get rejected where else router can replace
multiple filter and there is a default group in the router
which collect all the row which failed to satisfy the
condition in diffeent group in the router.
2). filter connected to a single target table where as
router
concted to multiple targets tables
3). Filter is active where as router can be active and
passive
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / srinivas
FILTER ROUTER
1.single condition 1.multiple condition
2.to load single target 2.to load multiple target
3.we are not able see 3.all rejected rows stored in
the rejected rows default group
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ravi awasthi
Router
1. Router transformation divides the incoming records into multiple groups based on some condition. Such groups can be mutually inclusive (Different groups may contain same record)
2. Router transformation itself does not block any record. If a certain record does not match any of the routing conditions, the record is routed to default group.
3. Router acts like CASE.. WHEN statement in SQL (Or Switch().. Case statement in C)
Filter
1. Filter transformation restricts or blocks the incoming record set based on one given condition.
2. Filter transformation does not have a default group. If one record does not match filter condition, the record is blocked.
3. Filter acts like WHERE condition is SQL.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / justin
Filter transformation is used to filter out unwanted records that does not satisfy its condition
Router Transformation provide you the flexibility of populating multiple target depending upon the different type of conditions
I was able to find a good article on it at
http://www.tecktricks.com/difference-between-filter-transformation-and-router-transformation-in-informatica/
Hope it will help you :)
| Is This Answer Correct ? | 1 Yes | 0 No |
what is runtime variable?
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
disable caching in a lookup transformation?
what is correlated query?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
with out using update strategy transnsformation how to update the data in mapping level
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
If u r using dynamic cache lookup port will be thier in thet which option u will select
Global and Local shortcuts. Advantages.
What is sequence generator transformation in informatica?
in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 Answers HCL, Thomson Reuters,
Teradata 
