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. Naming Conventions
  11. Glossary

Getting Started

Getting Started

Routing Department Data

Routing Department Data

  1. Create a Router transformation and name it RTR_DeptName. Then click
    Done
    .
  2. Drag the DeptID and DeptName ports from the DEPARTMENT Source Qualifier transformation to the RTR_DeptName Router transformation.
  3. Open RTR_DeptName.
  4. On the
    Groups
    tab, add two groups.
    Change the group names and set the filter conditions.
    The following table describes the group names and the filter conditions:
    Group Name
    Filter Condition
    Sales
    DEPTID = ‘SLS’
    Engineering
    DEPTID = ‘ENG’
  5. On the
    Ports
    tab, change the precision for DEPTNAME to 15.
  6. Click
    OK
    to close the transformation.
  7. In the workspace, expand the RTR_DeptName Router transformation to see all groups and columns.
  8. Click
    Repository
    Save
    .

0 COMMENTS

We’d like to hear from you!