August 2017
Beginner to intermediate
426 pages
9h 36m
English
Router transformation is a single input and multiple output group transformation. Router can be used in place of multiple filter transformations. Router transformation accepts the data once through the input group, 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 router transformation where we wish to load all the 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 ...
Read now
Unlock full access