Primary key reports
After a column analysis job for single column primary keys completes or for multiple column primary keys, you can create a report that shows a summary of the defined primary keys and candidate primary keys in your data. Defined primary keys are keys that were already defined in your data before you ran the analysis. Candidate primary keys are keys that were inferred during analysis.
There are four types of primary key analysis reports:
- Defined primary key summary report
- Shows a summary of the defined primary keys in your data.
- Defined primary key duplicate exceptions report
- Shows a summary of the defined primary keys that have duplicates in your data.
- Defined and candidate summary report
- Shows a summary of the defined primary keys and candidate primary keys in your data. Candidate primary keys are inferred during analysis.
- Candidate primary key duplicate exceptions report
- Shows a summary of the primary keys candidates that have duplicates in your data.