[Informatica] Router Transformation

Router Transformation

::Transformation type::

The Router transformation allows you to filter data based on one or more condition and gives and option to route the data to default group it it does not satisfy any of the conditions.
Thus Router is used when we want to test the data against more than one conditions. Router is always preffered over using multiple Filter transformations while filtering data over multiple conditions. This is beneficial performance-wise as well.

- A Router transformation consists of input and output groups, input and output ports, group filter conditions, and properties that you configure in the Designer
- There are two types of output groups: User-defined groups and Default group.
- The User-defined groups are used to test data on multiple conditions. We create ne user-defined group for each condition that you want to specify.
- The designer automatically creates the Default group once you add the first User-defined group. One cannot edit the Default group.  This group does not have a condition associated with it. The data that is not evaluated to TRUE by any of the user-Defined groups is routed through Default group.

For Example, you have Sales representatives from various states and you want filter out representatives belonging to each of the states Maharashtra, Gujrat and Haryana. This can be done by creating three user defined groups one each for Maharashtra, Gujrat and Haryana and then rout the data to their respective targets. Note that the Sales Representatives which belong to Jharkhand, Tamil Nadu or Karnataka are routed through the Default group.

- If a row meets more than one group filter condition, the PowerCenter Server passes this row multiple times. This makes the Router a Active Transformation.
- NULL values are not considered in comparision and are routed to Default group if there is no explicit condition for handling NULL values
- One cannot connect Output ports from two diffrent Output groups to a single input transformation.

The following example shows how a Router can be used to filter/redirect a record set based on multiple conditions.