About Key Analysis - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

Trillium performs key analysis automatically when you import data. The analysis uses only a sample of your data and attempts to find thekeys 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.