Getting Started

10.4.0
- 10.5.6
- 10.5.1
- 10.5

Back Next

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.

In the Designer, switch to the Mapping Designer and create a mapping.

Name the mapping m_EmployeeSalary.

Drag the Employees XML source definition into the mapping.

Drag the DEPARTMENT relational source definition into the mapping.

By default, the Designer creates a source qualifier for each source.

Drag the SALES_SALARY target definition into the mapping two times.

Rename the second instance of SALES_SALARY as ENG_SALARY.

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.

Tutorial Lesson 6

Creating an Expression Transformation

Creating Router Transformations

Completing the Mapping

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal