Router | Filter |
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) | Filter transformation restricts or blocks the incoming record set based on one given condition. |
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 | Filter transformation does not have a default group. If one record does not match filter condition, the record is blocked |
Router acts like CASE.. WHEN statement in SQL (Or Switch().. Case statement in C) | Filter acts like WHERE condition is SQL. |
What is the difference between Router and Filter
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment