Router transformation is an active and connected transformation. It is an extension of the filter transformation. Here in the router, we can give multiple filter conditions and pass the records that satisfy the filter conditions and route the rest of the records to the default group, whereas in the filter, we can give a single condition that connects to a single target, and records that do not satisfy the condition will be dropped or filtered out at the mapping level.
Router Transformation has two groups.
Input groups : Here we specify the group name with our choice.
Output groups : Here we specify the filter condition according to mapping logic
* Can't we use multiple filter transformations instead of using router transformation?
When multiple filters are used, each filter transformation reads all records and makes multiple passes over the same data. It will create performance issues.
When multiple filters are used, each filter transformation reads all records and makes multiple passes over the same data. It will create performance issues.
While Router passes records only a single time and uses it for multiple conditions.
No comments:
Post a Comment