Interested to Buy Any Domain ? << Click Here >> for more details...
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
How can we use batches?
what are the deliverables?in your project?
How do you update the records with or without using update strategy?
How many ways a relational source definition can be updated and what are they?
What is repository manager?
What is informatica? Why do we need it?
What all join we can perform in LOOKUP transformation?
What is the procedure for creating independent data marts from informatica 7.1?
Which transformation should we use to normalise the COBOL and relational sources?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What are the advantages of informatica?
What does reusable transformation mean?
Differentiate between sessions and batches?
What are roles and groups and benefits of using them?
