Performing Column Gap Analysis

A column gap analysis enables you to find:

  • Columns not existing in mappings
  • Source columns existing on mappings without valid target
  • Target columns listed on mappings without business rule and source column

You can perform column gap analysis at the following levels:

  • System
  • Environment
  • Table

To perform column gap analysis, follow these steps:

  1. Go to Application Menu > Data Catalog > Mapping Manager.
  2. In the Workspace Mappings pane, click a project.

    3. The Metadata Tree View pane appears on the right.Previewing Data Database

  3. In the Metadata Tree View pane, you can right-click a:
    • System: Use this option to run the analysis on all the columns under a system.
    • Environment: Use this option to run the analysis on all the columns under an environment.
    • Table: Use this option to run the analysis on all the columns under a table.

    For example, the following image displays the available options when you click a system.

    Column Gap Analysis Sys

  4. Click Column Gap Analysis.

    5. The Column Gap Analysis page appears.

    Column Gap Analysis Page

  5. Select projects and mappings.
  6. Click Icon Ok Database Options.

    7. The Column Gap Analysis Report for the selected projects and mappings appears.

    Column Gap Analysis Report