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
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is rank transformation?
How does the aggregator transformation handle null values?
tell me the rules and responsblites in our project(my project is development)
What is the benefit of session partitioning?
What are the restrictions of union transformation?
What is sequence generator transformation in informatica?
What is dimensional table?
Explain lookup transformation in informatica
Explain what transformation and how many are there in informatica?
How to join three sources using joiner?
Separate from an archive server and a powerhouse?
4 yrs etl devloper roles and responsibilities?any body give solutions
without table how to come first record only in oracle?
What is a joiner transformation and why it is an active one?