The Router transformation is an active transformation that you can use to apply a condition to incoming data.
In a Router transformation, Data Integration uses a filter condition to evaluate each row of incoming data. It tests the conditions of each user-defined group before processing the default group. If a row meets more than one group filter condition, Data Integration passes the row multiple times. You can either drop rows that do not meet any of the conditions or route those rows to a default output group.
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 following table compares the Router transformation to the Filter transformation:
Options
Router
Filter
Conditions
Test for multiple conditions in a single Router transformation
Test for one condition per Filter transformation
Handle rows that do not meet the condition
Route rows to the default output group or drop rows that do not meet the condition
Drop rows that do not meet the condition
Incoming data
Process once with a single Router transformation
Process in each Filter transformation
The following figure shows a mapping with a Router transformation that filters data based on region and routes it to a different target, either NA, EMEA, or APAC. The transformation routes data for other regions to the default target:
