About Key Analysis - trillium_discovery - trillium_quality - 17.1

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Topic type
Administration
Overview
How Do I
Configuration
Reference
Installation
First publish date
2008

Trillium performs key analysis automatically when you import data. The analysis uses only a sample of your data and attempts to find the keys that meet default criteria for uniqueness.

There are two types of keys:

  • Primary - Represents pieces of data (one or more attributes) that uniquely identify data and distinguish it from any other row within an entity.
  • Composite - A primary key that is made up of more than one attribute (field or column).

How Key Analysis Works

After you import data, the Control Center presents a list of potential keys found during the import. The initial key analysis samples a maximum of 10,000 rows of data and tries to find potential single-attribute (primary) and double-attribute (composite) key combinations that are at least 98% unique.

The keys that the Control Center shows you may or may not be the keys that you expect in your data. Therefore, review the keys that are found and verify whether they are valid. If you believe that the list of discovered keys is incomplete, and that the sample data size is too small or the uniqueness percentage too high, reset the criteria for the key search and re-run the key analysis. Delete any discovered keys that are coincidental or irrelevant to your data profiling needs.