Not Found
English

Page Not Found

The page or file you are looking for has been moved or no longer exists.

The following links might help you find the content you need:


You can also search the Documentation Portal or visit the home page.

English
  • PowerCenter 10.2
  • All Products

Table of Contents

Search

  1. Preface
  2. Product Overview
  3. Before You Begin
  4. Tutorial Lesson 1
  5. Tutorial Lesson 2
  6. Tutorial Lesson 3
  7. Tutorial Lesson 4
  8. Tutorial Lesson 5
  9. Tutorial Lesson 6
  10. Appendix A: Naming Conventions
  11. Appendix B: Glossary

Getting Started

Getting Started

Back Next

Routing Employee Salary Data

Routing Employee Salary Data

  1. Create a Router transformation and name it RTR_Salary. Then click
    Done
    .
  2. In the Expression transformation, select the following columns and drag them to RTR_Salary:
    • EmpID
    • DeptID
    • LastName
    • FirstName
    • TotalSalary
    The Designer creates an input group and adds the columns you drag from the Expression transformation.
  3. Open the RTR_Salary Router transformation and select the
    Groups
     tab.
    The
    Edit Transformations
     dialog box appears, with RTR_SALARY listed in the Select Transformation field.
    The following image shows the
    Groups
     tab in the
    Edit Transformations
     dialog box:
    ""
  4. On the
    Groups
     tab, add two groups.
    Change the group names and set the filter conditions.
    The following table describes the groups names and the filter conditions:
    Group Name
    Filter Condition
    Sales
    DEPTID = ‘SLS’
    Engineering
    DEPTID = ‘ENG’
    The Designer adds a default group to the list of groups. All rows that do not meet the condition you specify in the group filter condition are routed to the default group. If you do not connect the default group, the Integration Service drops the rows.
  5. Click
    OK
     to close the transformation.
  6. In the workspace, expand the RTR_Salary Router transformation to see all groups and ports.
  7. Click
    Repository
    Save
    .
Next, you create another Router transformation to filter the Sales and Engineering department data from the DEPARTMENT relational source.
0 COMMENTS
We’d like to hear from you!