Combining mapping models

You can combine the work of several groups in your enterprise that have mapped relationships by using the function to combine mapping models.

Before you begin

You must have at least two mapping models in the current Data Project Explorer view.

About this task

You can transform a series of relationships by combining mapping models from multiple mappings to one mapping, or from sequentially created mapping models to another mapping model.

Procedure

To combine mapping models:

  1. In the Data Project Explorer view, expand the data design project that you want to work with.
  2. Select Mappings.
  3. Right-click on a mapping model that you want to use as the model that you combine other models with.
  4. Select Combine Mapping to open the Combine Two Mapping Models window. The mapping type depends on the content of the mapping model that you selected. For example,
    Combine Parallel Mapping Models You combine mapping models in parallel when you create multiple mapping models that might contain different sources but use the same target. You combine two of these mapping models to merge information into a third mapping model.
    Combine Sequential Mapping Models You combine mapping models in a sequential order when you create a mapping model with a source and a target, and then use that target as the source for a second mapping model. This action creates a third mapping model that contains the source of the first mapping model and the target of the second mapping model.
  5. In the Combine with group box, specify a mapping model to combine with the mapping model that you selected in step 3.
  6. In the Resulting mapping model group box, specify a file name for the new mapping model.
  7. Click OK.

Results

Each group box contains source and target information that is related to the selected mapping model. The new mapping model that is a combination of two other mapping models is added to the data design project in the Data Project Explorer view and saved in the current workspace.


Feedback