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

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

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.

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 :)

In joiner, how to load Master table in Target?

2 Answers  

---

when will we go for unconnected lookup transformation in Informatica?

6 Answers   CTS, IBM,

---

4 yrs etl devloper roles and responsibilities?any body give solutions

0 Answers   TCS,

---

comonly how meny mappings r there in Banking projects?

1 Answers  

---

Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers  

---

How do you load first and last records into target table?

0 Answers  

---

In which scenario did u used Mapping variable?

1 Answers   Cognizant,

---

what are the types of facts with Examples?

3 Answers  

---

Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

5 Answers   Accenture, VAMA,

---

what is target update override and when we use it?

2 Answers   TCS,

---

What is the benefit of partitioning a session?

0 Answers  

---

What is the difference between a connected look up and unconnected lookup?

0 Answers  

---