Router
transformation is an active transformation that routes data into multiple
output groups based on one or more conditions. If you need to test the same
input data based on multiple conditions, use a Router transformation in a
mapping instead of creating multiple Filter transformations to perform the same
task. The Router transformation is more efficient.
Groups in Router Transformation
Input Group
The input group
includes all input ports that you add to the transformation.
Output Groups
1. User-Defined Groups
A
user-defined group consists of output ports and a group filter condition. You
can create and edit user-defined groups on the Groups tab with the Developer
tool. The Data Integration Service uses the condition to evaluate each row of
incoming data. If a row meets more than
one group filter condition, the Data Integration Service passes this row
multiple times.
2. The Default Group
The
Developer tool creates the default group after you create one user-defined
group. The Developer tool does not allow you to edit or delete the default
group. This group does not have a group filter condition associated with it. If
all of the group conditions evaluate to FALSE, the Data Integration Service
passes the row to the default group. If you want the Data Integration Service
to drop all rows in the default group, do not connect it to a transformation or
a target in a mapping.
Advanced Properties for Router Transformation
Tracing Level Amount of detail that appears in
the log for this transformation.
Scenario
Employees in
different departments to different tables.
*In case of any questions, feel free to leave comments on this page and I would get back as soon as I can.
