1.

What is the difference between Router and Filter?

Answer»

Router and FILTER are types of transformations offered by INFORMATICA. There are a few differences between them as given below:

Router transformationFilter transformation
Using router transformation, rows of data that don't meet the conditions are captured to a default output group.In this, data is tested for one condition, and rows that don't meet it are removed from the filter. 
It allows RECORDS to be divided into multiple groups based on the conditions specified. It doesn’t take CARE of the division of records. 
This transformation has a single input and multiple output group transformations. This transformation has a single input and a single output group transformation. 
There can be more than one condition specified in a router transformation. A single filter condition can be specified in filter transformation.
Input rows and failed records are not blocked by the router transformation. There is a possibility that records GET blocked in a filter transformation. 


Discussion

No Comment Found