This exercise teaches you how to create a mapping model that includes
the sources and targets from the models that you just accessed from the Data
Source Explorer.
To create a new mapping model:
- In the Data Project Explorer view, expand the mytestproject project.
- Right-click the Mappings folder and select to
open the Mapping Editor wizard. In the Enter or select
the parent folder field, the project name mytestproject is
displayed because it is the current project.
- In the File name field, specify myfirstmapping.msl as
the mapping model name. The model name must be unique within the
project.
- Click Next.
- On the Specify the Mapping Source page of the Mapping Editor wizard,
click Add to open the file browser. The
.dbm files in the current project that have not already been selected are
displayed. In this example, there are two source .dbm files that are displayed.
- Select Sample.dbm, and then click OK.
- Click Next. On the Specify
the Mapping Source page of the Mapping Editor wizard, the schemas that are
in the .dbm file appear in a tree view.
- Select the SAMP schema. The schemas that you select
will be part of the mapping model.
- Click Next.
- Click Browse on the Specify the Mapping
Target page of the Mapping Editor wizard. The file browser
displays the valid .dbm files.
- Select Sample2.dbm and click OK. On
the Specify the Mapping Target page of the Mapping Editor wizard, a schema
tree opens with all schemas selected. In this example, only one schema is
in the Sample2.dbm file (SAMP), and it is already selected.
- Click Next.
- On the New Mapping File Summary page of the Mapping Editor wizard,
view your selections in the summary window.
- Click Finish. The mapping
model that you created appears as an MSL file in the Mappings folder.
- Close the mapping model that you just created by clicking from
the workbench menu bar.
You now have a mapping model that contains source and target elements.