Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Differnce between filter and router?

Question Posted / ravi awasthi

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many types of sessions are there in informatica.please explain them?

1125

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1641

How does a rank transform differ from aggregator transform functions max and min?

1160

What are the settings that you use to configure the joiner transformation?

1017

Explain lookup transformation source types in informatica

1053

Write the unconnected lookup syntax?

1046

Is it possible to revert a global repository to local one and why?

1039

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7135

Explain what are the different versions of informatica?

1048

How to partition the Session?

1060

What does role playing dimension mean?

1012

What is a surrogate key?

1028

Why sorter is an active transformation?

1144

Can informatica load heterogeneous targets from heterogeneous sources?

1131

Explain the code page compatibility?

1030