Getting Started

Back Next

Creating a Mapping

In the following steps, you create a mapping and link columns in the source EMPLOYEES table to a Source Qualifier transformation.

Click

Tools

Mapping Designer

to open the Mapping Designer.

In the Navigator, expand the Sources node in the tutorial folder, and then expand the DBD node containing the tutorial sources.

The following image shows the contents of the Sources node in the tutorial folder:

Drag the EMPLOYEES source definition into the Mapping Designer workspace.

The Designer creates a new mapping and prompts you to provide a name.

In the

Mapping Name

dialog box, enter m_PhoneList, and click

The recommended naming convention for mappings is m_Mappingname.

The source definition appears in the workspace. The Designer creates a Source Qualifier transformation and connects it to the source definition.

Expand the Targets node in the Navigator to open the list of all target definitions.

Drag the T_EMPLOYEES target definition into the workspace.

The target definition appears.

Click

Layout

Arrange

In the

Select Targets

dialog box, select T_EMPLOYEES target, and click

The Designer rearranges the mapping.

The final step is to connect the Source Qualifier transformation to the target definition.