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

to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?

3 Answers   IBM,

---

Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks

4 Answers   IBM,

---

what is lookup chache?

1 Answers   Patni,

---

What is source qualifier?

6 Answers   SDS,

---

What is confirmed dimension?

3 Answers  

---

---

How informatica process data means how informatica works?

2 Answers   TCS,

---

How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers   Puma,

---

Performance tuning( what you did in performance tuning)

0 Answers   Infosys,

---

what is meant by lookup caches?

2 Answers   Cap Gemini, Informatica,

---

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

0 Answers  

---

In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process

2 Answers   Wipro,

---

what is the method of error handling when session is running?

1 Answers   TCS,

---