.png%3Falt%3Dmedia%26token%3D2bb9ee51-62f4-4b85-b6f0-ffede19ed7da)
.png%3Falt%3Dmedia%26token%3D2bb9ee51-62f4-4b85-b6f0-ffede19ed7da)
Uniqueness
The number of records that can be identified uniquely based on a predefined key.
Good to know: Uniqueness is the inverse of duplicates.
.png?alt=media&token=152ecdfa-560b-4211-967d-2972b2c80245)
Prerequisite for this is that primary key defined
Formula : 1 – primary_key_count / total_row_count
Common unit of Measure: Value count or percentage
Three different problems uniqueness could have occurred:
One record with one key value occurs more than once in a dataset (duplicate with identical key values). The two records are not unique.
Key | Student Name
22 | John snow
22 | John snow
Often times Datastore constraints can easily help avoid this issue.
Multiple records with same values occur more than once in a dataset (duplicate with different key values). Object John is not unique in the dataset.
Key | Student Name
22 | John snow
37 | John snow
A record has the same key as another record, and both occur in a dataset (false duplicate). Key 22 is not unique.
Key | Student Name
22 | John snow
37 | John snow
Most often users will need use sophisticated master data management and Identify resolution systems for resolving duplicates like these.
Related dimension: Consistency