Database Reference
In-Depth Information
The Router transformation
Router transformation is single input to multiple output group transformation. Routers can
be used in place of multiple Filter transformations. Router transformations accept the data
through an input group once, and based on the output groups you define, it sends the data
to multiple output ports. You need to define the filter condition in each output group.
A mapping using the Router transformation where we wish to load all records from
LOCATION
as
INDIA
in one target, records from
UK
in another target, and all other non-
matching records in the third target, is indicated in the following screenshot:
When you drag the columns to the router, the Router transformation creates an input group
with only input ports and no output port. To add the output groups, click on the
Groups
tab
and add two new groups. Enter the name of each group under the group name and define
the filter condition for each group. Click on
OK
to create the output groups in the Router
transformation.
