What Is Data Cardinality?
Ch KashifEnlightened
Power BI
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this answer should be reported.
What Is Data Cardinality?
Ch Kashif
Cardinality is the term used in database relations to denote the occurrences of data
on either side of the relation.
There are 3 basic types of cardinality:
High data cardinality:
Values of a data column are very uncommon. e.g. email ids and the user names.
Normal data cardinality:
Values of a data column are somewhat uncommon but never unique.
e.g. A data column containing LAST_NAME (there may be several entries of the same last name).
Low data cardinality:
Values of a data column are very usual. e.g. flag statuses: 0/1