Mapping Source and Target

You can create mapping specifications using drag and drop method, even when source column names are different from target column names. After mapping source to target, you can set the target update strategy and enter a description about the strategy.

To create mapping specifications using drag and drop method, follow these steps:

  1. Under the Workspace Mappings pane, click the required map.

    2. By default, it opens the Mapping Specification tab.

  2. Click .

    3. You can now, edit the Mapping Specification tab.

  3. Drag source table or column from Metadata Catalogue and drop in Mapping Specification.

    4. You cannot drop source system or source environment in Mapping Specification. Ensure that you drop source table or column under the respective column.

  4. Drag target table or column from Metadata Catalogue and drop in Mapping Specification.

    5. You cannot drop target system or target environment in Mapping Specification. Ensure that you drop target table or column under the respective column.

  5. Click .

    6. The mapping specification is saved.

To set the target update strategy, follow these steps:

  1. Expand the Additional Mapping Information pane.

    2. The pane is available at bottom of the central pane when you click the map in Workspace Mappings.

  2. Click the Target Update Strategy tab.
  3. In the Target Update Strategy tab, click .
  4. Click the required strategy, enter Update Strategy Description, and click .

The target update strategy is set.

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