Configuration Guide

10.4

Back Next

Step 1. Configure the Mappings

You need to create a mapping with source, target, and transformation objects. After you add the mapping objects, you need to link the ports between mapping objects. Finally, validate the mappings.

Create a mapping to transform data and load it into the staging tables.

Select a project or folder in the

Object Explorer

view.

Click

File

New

Mapping

The following image shows the Mapping dialog box with the Name and Location fields:

Enter a mapping name.

Click

Finish.

An empty mapping appears in the editor.

The following image shows the Mapping_C_S_CRM_CUST empty mapping:

Add objects to the mapping to determine the data flow between sources and targets.

Drag the physical data object that you created for the source to the editor and select

Read

to add the data object as a source.

Drag the logical data object that represents the staging table to the editor and select

Write

to add the data object as a target.

The following image shows the Mapping_C_S_CRM_CUST mapping with a physical data object and a logical data object:

Link ports between mapping objects.

You can manually link ports or link ports automatically.

After you edit, add, or delete a staging table column and synchronize the Model repository with the Hub Store, the corresponding mapplet ports are disconnected. You must manually connect the affected ports.

The following image shows the Mapping_C_S_CRM_CUST mapping with links between the physical data object and the logical data object: