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

Completing the Mapping

Completing the Mapping

Connect the Router transformations to the targets to complete the mapping.
  1. Connect the ports from RTR_Salary groups to the ports in the XML target definitions.
    The following table describes the ports in RTR_Salary groups and the ports in the XML target definitions:
    Router Group
    Router Port
    Target
    Target Group
    Target Port
    Sales
    EMPID1
    SALES_SALARY
    EMPLOYEE
    EMPID
    Sales
    DEPTID1
    SALES_SALARY
    EMPLOYEE
    DEPTID (FK)
    Sales
    LASTNAME1
    SALES_SALARY
    EMPLOYEE
    LASTNAME
    Sales
    FIRSTNAME1
    SALES_SALARY
    EMPLOYEE
    FIRSTNAME
    Sales
    TotalSalary
    SALES_SALARY
    EMPLOYEE
    TOTALSALARY
    Engineering
    EMPID3
    ENG_SALARY
    EMPLOYEE
    EMPID
    Engineering
    DEPTID3
    ENG_SALARY
    EMPLOYEE
    DEPTID (FK)
    Engineering
    LASTNAME3
    ENG_SALARY
    EMPLOYEE
    LASTNAME
    Engineering
    FIRSTNAME3
    ENG_SALARY
    EMPLOYEE
    FIRSTNAME
    Engineering
    TotalSalary3
    ENG_SALARY
    EMPLOYEE
    TOTALSALARY
    The following figure shows the Router transformation connected to the target definitions:
    ""
  2. Connect the ports from RTR_DeptName groups to the ports in the XML target definitions.
    The following table describes the ports in RTR_DeptName and the ports in XML target definitions:
    Router Group
    Router Port
    Target
    Target Group
    Target Port
    Sales
    DEPTID1
    SALES_SALARY
    DEPARTMENT
    DEPTID
    Sales
    DEPTNAME1
    SALES_SALARY
    DEPARTMENT
    DEPTNAME
    Engineering
    DEPTID3
    ENG_SALARY
    DEPARTMENT
    DEPTID
    Engineering
    DEPTNAME3
    ENG_SALARY
    DEPARTMENT
    DEPTNAME
  3. Click
    Repository
    Save
    .
    The mapping is now complete. When you save the mapping, the Designer displays a message that the mapping m_EmployeeSalary is valid.
    The image shows the mapping m_EmployeeSalary:
    The mapping contains an XML source, an XML Source Qualifier transformation, Expression transformation, and target. The mapping also contains a relational source, Source Qualifier transformation, Router transformation, and target. The Expression transformation also connects to the second target.

0 COMMENTS

We’d like to hear from you!