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

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!