Router Transformation in Informatica with Example

Router Transformation in Informatica , is a connected and active transformation which let you to transfer data to multiple target depending upon the different condition. A Filter transformation rejects the row which don't satisfy its condition whereas Router Transformation allows you to pass the failed data to some default target as well.

Router Transformation informatica

Business scenarios of Router Transformation

Unlike Filter Transformation , Router Transformation provide you the flexibility of populating multiple target depending upon the different type of conditions. It also allow you to add multiple condition for each target .Failed records can also be extracted from the default group.

Is Router Transformation Active or Passive ?

Router Transformation in Informatica is an active transformation a its Routes data into multiple groups based on group conditions

Is Router Transformation Connected or Unconnected ?

Router Transformation is a Connected Transformation.

How to use Router transformation in Informatica

Use the following procedure to create an Router transformation in Informatica mapping.

Steps to create an Router transformation:

• In the Mapping Designer, open a Mapping.
• Click Transformation > Create. Select Router transformation.

• You can also select Transformation by clicking  function  button on Informatica Designer

• Enter a name and click Done.
• You can create ports in Router transformation  by selecting and dragging it from input transformation to router transformation.You can manually create input ports on the Ports tab by double clicking on it.
• Double-click the title bar of the Router to open the transformation
• Click the Groups tab, and then click the Add button to create a user-defined group.

• To add Group
  • Click the Groups tab.
  • Click the Add button.
  • Enter a name for the new group in the Group Name section.
  • Click the Group Filter Condition field and open the Expression Editor.
  • Enter the group filter condition.
  • Click Validate to check the syntax of the condition.
  • Click OK.

• 

  Router Transformation step 4

• The Designer creates the default group when you create the first user-defined group
• Click the Transformation tab and configure transformation properties. ( change Tracing Level as per your need)

• Click OK.
• Connect group output ports of router to other transformations or targets

Note: After you make the transformation reusable, you cannot copy ports from the source qualifier or other transformations. You can create ports manually within the transformation.

Example  of Router Transformation

Check example of Router Transformation in informatica

Incoming Search Terms :

rank transformation in informatica
rank transformation in informatica with example
rank transformation example in informatica
how to add rank transformation in informatica mapping
rank transformation groups
example of rank transformation in informatica
router transformation in informatica interview questions
default group in router transformation in informatica
router transformation in informatica is active or passive