Tuesday 21 August 2012

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.

1 comment: