Creating One to Many and Many to Many Mapping Specifications

You can map multiple source columns to a single or multiple target columns to create a mapping specification. After creating mapping specification, you can set the target update strategy and enter a description about the strategy.

Creating Mapping Specification

To create one to many or many to many mapping specifications, follow these steps:

  1. Under the Workspace Mappings pane, click the required map.
  2. In Mapping Specification, click .
  3. Switch to ON to enable the append mode.

    4. The append mode enables you to drop multiple columns from Metadata Catalogue in one row of the Mapping Specification grid.

  4. Drag one or multiple source columns from Metdata Catalogue in Mapping Specification under the Source Columns Name.

    5. Note: Use Ctrl key to select multiple columns in Metadata Catalogue.

  5. Drag single or multiple target columns from Metadata Catalogue in Mapping Specification under the Target Columns Name.
  6. Click .

    7. The mapping specification is saved.

    You can view the mapping specification in the Graphical Designer tab to view the graphical representation of the many to one mappings.

Setting Target Update Strategy

To set target update strategy, follow these steps:

  1. Expand the Additional Mapping Information pane and click the Target Update Strategy tab.
  2. In the Target Update Strategy tab, click .

  3. Click the required strategy, enter Update Strategy Description, and click .
  4. Click .

    5. The source to target mapping is saved.

You can enrich a mapping specification by:

After creating a mapping specification, you can analyze a mapping specification. Analyzing mapping specification involves:

  • Generating virtual preview of target
  • Previewing Data
  • Performing table gap analysis
  • Performing column gap analysis
  • Running impact analysis
  • Running lineage analysis
  • Running end to end lineage
  • Opening business view
  • Viewing mapping statistics