Mapping Conversion

A PDM-PDM mapping is specified in a query or a textual expression defined in a target table, and from which its source(s) and associated model(s) can be retrieved.

When you select a target mapped table, the wizard creates the corresponding output and retrieves the input sources from the mapped table. Additional objects (actions) can be created, if at least one of the following situations occurs:

The mapped table owns criteria (Where, Group by).
The mapped table has more than one source.
The columns of the mapped table have more than one source.

In the following example, the GiantCorp target table is mapped to the Acme and BlueCorp source tables, has Where and Group by criteria, and has an Address column mapped to the Street and City source columns:

The Convert Mappings to ETL Wizard will create the following objects in a data transformation diagram:

The Acme and BlueCorp data inputs and a data join for the source tables.
A data calculator for the two column sources and the Where criterion.
A data aggregation for the Group by criterion.
The GiantCorp data output for the mapped target table.