Use the Router transformation to evaluate data based on one or more conditions and route the rows of data that meet each condition into a separate output group. Optionally, you can route rows of data that do not meet any of the conditions to a default output group.

When you configure a Router transformation, you can define one or more router groups. These groups have the same ports. When you generate mappings from the mapping template, unique numeric suffixes are assigned to the names of the output ports in each group.

The following table describes the required properties for the Router transformation:

The suffix follows the order in which the groups are listed in the Router configuration window.

For example, the following table describes the groups that you define for a Router transformation:

When you generate mappings from a mapping template, PowerCenter assigns the following suffixes to the groups:

When you create the rules for the links that start from a Router transformation, identify the group associated with the link. The rules must refer to port names with the suffix for the associated group.

If you create rules that refer to port names with the suffix for another group, you cannot generate mappings from the mapping template.