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

Creating a Mapping with XML Sources and Targets

Creating a Mapping with XML Sources and Targets

In the following steps, you create a mapping to transform the employee data. You add the following objects to the mapping:
  • The Employees XML source definition you created.
  • The DEPARTMENT relational source definition you created in Creating Source Definitions.
  • Two instances of the SALES_SALARY target definition you created.
  • An Expression transformation to calculate the total salary for each employee.
  • Two Router transformations to route salary and department.
You pass the data from the Employees source through the Expression and Router transformations before sending it to two target instances. You also pass data from the relational table through another Router transformation to add the department names to the targets. You need data for the sales and engineering departments.
  1. In the Designer, switch to the Mapping Designer and create a mapping.
  2. Name the mapping m_EmployeeSalary.
  3. Drag the Employees XML source definition into the mapping.
  4. Drag the DEPARTMENT relational source definition into the mapping.
    By default, the Designer creates a source qualifier for each source.
  5. Drag the SALES_SALARY target definition into the mapping two times.
  6. Rename the second instance of SALES_SALARY as ENG_SALARY.
  7. Click
    Repository
    Save
    .
    The Designer displays a warning that the mapping m_EmployeeSalary is not valid because you have not completed the mapping.
Next, you add an Expression transformation and two Router transformations. Then, you connect the source definitions to the Expression transformation. You connect the pipeline to the Router transformations and then to the two target definitions.

0 COMMENTS

We’d like to hear from you!