Router Transformation

1. Router Transformation
   

 

Router transformation tests same input data based on multiple conditions and gives the option to route rows of data that do not meet any of the conditions to a default output group.

Working with Groups

 

Router has the following types of groups.

 

• Input Group : The designer copies property information from the input ports of the input group to create a set of output ports for each output group.
  

 

• 
  Output Group : There are two types of output groups.
  

    è User-defined Groups

    è Default Group

 

We cannot delete or modify output ports or properties.

 

User defined Group

 

The Designer creates the default group after we create one new user-defined group. The designer does not allow to edit or delete the default group. This group does not have a group filter condition associated with it. If all the conditions evaluate to FALSE, the IS passes the row to the default group.

 

• If you want to drop all rows in the default group, do not connect it to transformation or target.
  
• The Designer deletes the default group when we delete the last user-defined group from the list.
  

 

• We can enter default values for input ports in Router to replace NULL input values.
  
• If a row meets more than one group filter condition, the IS passes this row multiple times.
  

 

• We can connect one group to one transformation or one target.
  
• We can connect one output port in a group to multiple transformations or targets.
  
• We can connect multiple output ports in one group to multiple transformations or targets.
  
• We cannot connect more than one group to one transformation or target.
  

1. Router Transformation
   

 

Router transformation tests same input data based on multiple conditions and gives the option to route rows of data that do not meet any of the conditions to a default output group.

Working with Groups

 

Router has the following types of groups.

 

• Input Group : The designer copies property information from the input ports of the input group to create a set of output ports for each output group.
  

 

• 
  Output Group : There are two types of output groups.
  

    è User-defined Groups

    è Default Group

 

We cannot delete or modify output ports or properties.

 

User defined Group

 

The Designer creates the default group after we create one new user-defined group. The designer does not allow to edit or delete the default group. This group does not have a group filter condition associated with it. If all the conditions evaluate to FALSE, the IS passes the row to the default group.

 

• If you want to drop all rows in the default group, do not connect it to transformation or target.
  
• The Designer deletes the default group when we delete the last user-defined group from the list.
  

 

• We can enter default values for input ports in Router to replace NULL input values.
  
• If a row meets more than one group filter condition, the IS passes this row multiple times.
  

 

• We can connect one group to one transformation or one target.
  
• We can connect one output port in a group to multiple transformations or targets.
  
• We can connect multiple output ports in one group to multiple transformations or targets.
  
• We cannot connect more than one group to one transformation or target.