Database Reference
In-Depth Information
When you add the group, a
DEFAULT
group gets created automatically. All nonmatching
records from the other groups will pass through the default group if you connect the
DEFAULT
group's output ports to the target.
When you pass the records to the Router transformation through the input group, the
Router transformation checks the records based on the filter condition you define in each
output group. For each record that matches, the condition passes further. For each record
that fails, the condition is passed to the
DEFAULT
group.
As you can see, Router transformations are used in place of multiple Filter transforma-
tions. This way, they are used to enhance the performance.
