|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.|
Saturday, March 16, 2013
What is the difference between Router and Filter?
Following differences can be noted,