Differnce between filter and router?
- 14 Answers
- 39291 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 |
I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent
is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?
supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How
How to use pmcmd utility command?
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
Design time, run time. If you don't create parameter what will happen
What are the options in the target session of update strategy transsformatioin?
What are teh different tasks that can be created in workflow manager?
2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?
Teradata 
