Auto-Map

You can create a map and proceed with auto-map to create a mapping specification when source column names and target column names are same. For more information about creating maps, refer to the Creating Maps topic.

After creating a mapping specification, you can set the target update strategy and enter a description about the strategy.

Creating Mapping Specifications

To create mapping specifications using auto-map, follow these steps:

  1. On the Creating New Mapping Wizard page, drag the target table from the Metadata pane and drop it in the Target Object(s) box.
  2. Drag source table from the Metadata pane and drop it in the Source Object(s) box.

  3. Click .

    4. The source columns are mapped with the target columns under a mapping group with the target table name. The mappings can be previewed in the Auto Mapping Preview Grid, which gives information about the target and source tables.

    Use the following options to manage the auto-map:

    Maximize ()

    Use this option to maximize or minimize the Auto Mapping Preview Grid.

    Delete Orphan Sources ()

    Use this option to delete source attributes that are not mapped.

    Delete Orphan Targets ()

    Use this option to delete target attributes that are not mapped.

    Add Transformations ()

    Use this option to add transformations for the auto map. You can add business rule, extended business rule transformation, look up reference column, lookup on, and trans look up condition.

    Add Group

    Use this option to add a mapping group to perform other mappings.

    Rename Mapping Group ()

    Use this option to rename a mapping group.

    Delete Group

    Use this option to delete a mapping group. To delete a mapping group, click the mapping group and then click Delete Group.

    Create a distinct Mapping for every Group

    Use this option to create distinct mapping for every group.

  4. Click Finish.

A new map is created and saved under the Mappings tree. All the auto-maps in the multiple mapping groups appear in the same sequence in the Mapping Specification grid.

Setting Target Update Strategy

To specify target update strategy, follow these steps:

  1. Expand the Additional Mapping Information pane.

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

  2. Click the Target Update Strategy tab.

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

The target update strategy is set.

Adding Transformations

You can add transformations to an auto-map and specify whether it is applicable to exact match, orphan source, orphan target, or all the rows.

To add transformations in auto-maps, follow these steps:

  1. Under the Auto Mapping Preview Grid section, click .

    2. The Auto Map Transformation page appears.

  2. Click .

    3. A row is added to the grid.

  3. Double-click the cell under the Key column and select the required transformation.
  4. Double-click the cell under the Value column and select the value.

    5. You can use transformations created under the Transformations node only for Business Rule. For other transformations, enter the required value.

  5. Use the following options:
    Exact Match
    Use this option to apply the transformation on the exactly matched rows in the Auto Mapping Preview Grid.
    Orphan Source
    Use this option to apply the transformation on the orphan source rows in the Auto Mapping Preview Grid.
    Orphan Target
    Use this option to apply the transformation on the orphan target rows in the Auto Mapping Preview Grid.
    All
    Use this option to apply the transformation on every row in the Auto Mapping Preview Grid.
  6. Click .

    7. The transformations are added to the auto map.

You can enrich a mapping specification by:

After creating a mapping specification, you can analyze a mapping specification. Analyzing mapping specifications 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