Router transformation

The Router transformation is an active and connected transformation.
A Router transformation is similar to a Filter transformation because both transformations allow you to use a condition to test data. A Filter transformation tests data for one condition and drops the rows of data that do not meet the condition. However, a Router transformation tests data for one or more conditions and gives you the option to route rows of data that do not meet any of the conditions to a default output group.

A Router transformation consists of input and output groups, input and output ports, group filter conditions, and properties that we configure in the Designer.

Working with Router transformation:

1. Import/ create soure and target.
2. In the mapping drag source, target, create Router transformation .
3. Edit Router Transformation. Go to Groups Tab
4. Click the Groups tab, and then click the Add button to create a user-defined group. The default group is created automatically..
5. Click the Group Filter Condition field to open the Expression Editor.
6. Enter a group filter condition.
7. Click Validate to check the syntax of the conditions you entered.
8. Create another group if neccessary.
9. The rest of the records not matching the above conditions will be passed to DEFAULT group.
10. Click OK -> Click Apply -> Click Ok.
11. Now connect the ports from router to target tables.
12. Then validate Mapping and save.
13. Create Session and Workflow. Run the workflow