Primary Key Analysis Report

Key Analysis provides a report that shows which columns in a data source can be used individually, or in combination, to uniquely identify a row. The columns identified in this report are candidates for key column(s).

Procedure: How to View Key Analysis for a Synonym or Segment

To view key analysis for a synonym or segment:

Open the synonym in the Synonym Editor.
Right-click the synonym or segment name, select Data Profiling, and then Key Analysis.
If you selected a segment name, skip to step 4. All columns in the segment will be selected.

Note: Key Analysis is also available from the navigation pane by right-clicking a synonym, selecting Data Profiling, and then Key Analysis.
Select the columns that you would like to analyze as potential keys to the source table. Then, click on sample data.
The report shows:
segment

The selected segment.

name

The name of the segment.

format

The format of each column.

elements

The number of elements (columns) shown.

count

The number of rows.

distinct count

The number of distinct rows.

distinct percent

The percentage of rows that are distinct. This value must be 100% for a combination of columns to be used as key.

duplicate count

The number of duplicate values.

duplicate percent

The percentage of duplicate values. This value must be 0% for a combination of columns to be used as key.