What is Difference between Router and Filter Transformation

Similarity - A Router and Filter transformation are almost same because both transformations allow you to use a condition to test data.

Difference - A Filter transformation tests data for one condition and drops the rows of data that do not meet the condition. However, a Router transformation tests data for one or more conditions and gives you the option to route rows of data that do not meet any of the conditions to a default output group.

Advantages of Router Transformation over Filter Transforamtion -

• Better Performance; because in mapping, the Router transformation Informatica server processes the input data only once instead of as many times as you have conditions in Filter transformation.
• Less complexity; because we use only one Router transformation instead of multiple Filter transformation.