Creating a mapping model

A mapping model contains the information that defines the relationships between the source and target schemas that you specified, including transformations, join conditions, filters, sort conditions, and annotations.

Before you begin

About this task

You can use the mapping model to find or document relationships, and to generate statements that query or manipulate your data sources by using these relationships. You can create a mapping model with the Mapping Editor wizard and modify the model with the mapping editor. You can specify source and targets when you create the mapping model using the Mapping Editor wizard, or you can add sources and targets to the existing mapping model with the mapping editor.

Note: You can also choose to create a script when you create your mapping model. If you disable the script generation option, then the performance of the mapping model can improve. However, you cannot enable script generation on a mapping model after you have created the model.

You cannot generate scripts if your mapping model has more than one source data model file.

Procedure

To create a mapping model:

  1. Open the Mapping Editor wizard.
  2. Complete the steps of the wizard.
    Note: Configuring source and target schemas with the Mapping Editor wizard is always optional. You can add source and target schemas to an existing model at any time.

Results

The mapping editor displays the source data models that you selected on the left side of the editor. The source can contain one or more source files that can contain multiple schemas. The mapping editor displays the single target file that you selected on the right side of the editor. The target file can contain multiple schemas.

The mapping models that you create are stored under the current data design project. The contents of the data design project are physically stored on a file system folder on your client machine. The mapping model is stored in the .msl file. You can save or open an .msl file in any data design project. When you open an .msl file it opens inside the mapping editor. You can have multiple mapping editors open at the same time but only one editor is visible at a time. When you exit the application, you are asked to save any uncommitted changes.

The advantage of saving objects on the local workspace is that you can work with your .msl mapping model in a disconnected mode. Save the .msl file in the active mapping editor by clicking File > Save. You can save to any data design project within the Data Project Explorer view by clicking File > Save As. The name of an msl file must be unique within the data design project.


Feedback