Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Creating a Data Subset
  8. Performing a Data Masking Operation
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Working with Test Data Warehouse
  13. Analyzing Test Data with Data Coverage
  14. Plans and Workflows
  15. Monitor
  16. Reports
  17. ilmcmd
  18. tdwcmd
  19. tdwquery
  20. Data Type Reference
  21. Data Type Reference for Test Data Warehouse
  22. Data Type Reference for Hadoop
  23. 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.