Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Data Subset
  8. Data Masking
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Data Sets
  13. Plans and Workflows
  14. Monitor
  15. Reports
  16. ilmcmd
  17. tdwcmd
  18. tdwquery
  19. Data Type Reference
  20. Data Type Reference for Test Data Warehouse
  21. Data Type Reference for Hadoop
  22. Glossary

Primary Key Results

Primary Key Results

The primary key results is a list of possible primary keys that you can add to tables that do not have keys. Use the unique percentage value in the profile results to determine which column or combination of columns that you might add as a primary key for a table.
The following image shows sample primary key profile results:
The primary key profile results view shows the column, relationship type, uniqueness percentage, verification status, existing constraints, and status of the tables.
To view primary key results, close the profile and open it again to display the results. Click the
Profile | Primary Key
view. Examine the primary key profile results. The primary key candidates include the percentage of unique values in a column or combination of columns.
The following table describes the fields in the primary key results:
Property
Description
Table Name
The name of the table that contains the column with the primary key candidate.
Column Name
The name of the column or combination of columns that the Data Integration Service infers to be a primary or unique key.
Relationship
The function of the column in the table is primary key.
Uniqueness
The percentage of unique values in the column. Use the unique percentage value in the profile results to determine which column or combination of columns to add as a primary key. A unique percentage of 100 indicates that all values in the column are unique.
Verified
Indicates whether the primary key candidate has been verified as not containing another constraint.
Existing constraints
Shows any existing primary key or foreign key constraint for the column.
Status
Indicates whether a user verified, approved, or rejected the primary key candidate.