The differences are:
Advantages of Router transformation over Filter transformation:
- 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 transformations.
- Router transformation is more efficient than Filter transformation.
For E.g.:
Imagine we have 3 departments in source and want to send these records into 3 tables. To achieve this, we require only one Router transformation. In case we want to get same result with Filter transformation then we require at least 3 Filter transformations.
Similarity:
A Router and Filter transformation are almost same because both transformations allow you to use a condition to test data.