You can use mapping tables to define relationships between dimensions. Mappings are used in scenarios where you can define the mapping once and reuse it in multiple synchronizations.
When you create mapping tables, you can select multiple source application dimensions, but only one destination application dimension. The relationship displayed signifies that source dimension(s) members are used as members in the destination dimension. You can define one-to-one, one-to-many, and many-to-one relationships. Data synchronization leverages:
Mapping tables, to perform simple or complex transformations, and
A transformation engine to map from external sources or from application to application.
You use the Mapping Table Designer to create mapping tables. See Creating Mapping Tables in the Dimension Mapping and Creating Mapping Tables in the Data Synchronizer.
You can edit mapping tables in the Data Synchronizer, see Editing Mapping Tables.