ROUTER TRANSFORMATION

1
ROUTERTRANSFORMATION

• Basics and Advanced Concepts

2
TRANSFORMATIONS

• Transformations help to transform the source data
  according to the requirements of target system
  and it ensures the quality of the data being
  loaded into target.
• Transformations are of two types
• 1) Active
• 2) Passive

3

• Router Transformation is a Connected, Active
  transformation

4
Router transformation and Filter

• A Router transformation is similar to a Filter
  transformation because both transformations allow
  you to use a condition to test data
• 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.

5
(No Transcript)
6
Working with Groups

• A Router transformation has the following types
  of groups
• Input
• Output
• 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 Groups
• There are two types of output groups
• User defined
• Default

7
(No Transcript)
8
User-Defined Groups

• create a user-defined group to test a condition
  based on incoming data
• consists of output ports and a group filter
  condition
• Create one user-defined group for each condition
  that you want to specify
• The PowerCenter Server uses the condition to
  evaluate each row of incoming data

9
The Default Group

• The Designer creates the default group after you
  create one new user-defined group
• Does not have a group filter condition associated
  with it
• all of the conditions evaluate to FALSE, the
  PowerCenter Server passes the row to the default
  group

10

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

11
Using Group Filter Conditions

• We can test data based on one or more group
  filter conditions
• Create group filter conditions on the Groups tab
  using the Expression Editor
• Enter any expression that returns a single value
• We can also specify a constant for the condition

12

• A group filter condition returns TRUE or FALSE
  for each row that passes through the
  transformation, depending on whether a row
  satisfies the specified condition
• Server passes the rows of data that evaluate to
  TRUE to each transformation or target that is
  associated with each user-defined group

13
Using a Router Transformation in a Mapping
14
Specifying Group Filter Conditions
15
Adding Groups

• 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

16
Working with Ports
17
Input Port Name and Corresponding Output Port
Names
18
Creating a Router Transformation

• Select Router transformation, and enter the name
  of the new transformation. The naming convention
  for the Router transformation is
  RTR_TransformationName. Click Create, and then
  click Done
• Select and drag all the desired ports from a
  transformation to add them to the Router
  transformation, or you can manually create input
  ports on the Ports tab
• Click the Groups tab, and then click the Add
  button to create a user-defined group.
• The Designer creates the default group when you
  create the first user-defined group

19

• Click the Group Filter Condition field to open
  the Expression Editor.
• Enter a group filter condition
• Click Validate to check the syntax of the
  conditions you entered and click OK
• Connect group output ports to transformations or
  targets
• Choose Repository-Save

20

• 
  
• 
  Thank You !!!