Performing Table Gap Analysis

You can perform a table gap analysis and find:

  • Tables not being used in mappings
  • Tables existing on mapping without valid source or target

You can perform table gap analysis at the following levels:

  • System
  • Environment
  • Table

To perform table 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.

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

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

  4. Click Table Gap Analysis.

    5. The Table Gap Analysis page appears.

  5. Select projects and mappings.
  6. Click .

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