Adding a many-to-many mapping

Before you start:
Define your source and target by following the instructions in any of the following topics:

This topic describes how to add a many-to-many mapping.

  1. In the Source view, Ctrl+click to select the mapping sources and target values that you want to map.
  2. Right-click one of the selected values and click Create Mapping.
  3. Define how the assignment is to be made to the target by clicking the Target Value for the assignment, then clicking the box that appears at the end of the row. The Compose Expression editor appears, and you can qualify your assignment.
  4. Click OK to return to the Overview view.

After the values have been assigned, use the Compose Expression editor to describe the conditions when the mappings should occur. In the Compose Expression editor, you can add mapping expressions that refer to sources and targets that have not been included as mapping inputs.

Many-to-many mappings are available only for database-targeted mappings.

Related concepts
Mappings
Mapping types
Message mapping
Many-to-many mapping
Related tasks
Adding a one-to-one mapping
Adding a one-sided mapping
Adding a one-to-many mapping
Adding a many-to-one mapping
Adding a case mapping
Adding a repeating mapping
Related reference
Mappings