Primary Key Analysis
WHY IS PRIMARY KEY ANALYSIS IMPORTANT?
Primary Key Analysis is essential for any company to develop or locate data across separate data sets / databases.
Without this knowledge or understanding, no company can fully understand or utilise their Enterprise level data.
We can return values for possible Primary Keys that you could use.
Selecting the final Primary Key has to be a manual process, as it is possible that more than one column can be 100% Unique. At this point it is up to you to decide what you want to use as the Primary Keys.
- Creates links between two files
- Can create a unique key that can be used as a primary key in the absence of a pre- existing primary key
- Allows data relationship discovery to be completed with ease if there are no primary or foreign keys within the data