What is granularity : Granularity is the measure of grain for any table. Facts are usually designed at the lowest level of granularity, such that we can trace the lowest level of details when needed.
What is Cardinality : Opposite to Granularity, cardinality is calculated at the column level. Cardinality refers to the number of unique values a table has. For example in a customer table Customer Name would have higher cardinality than location, whereas Customer ID would have the highest cardinality of one or 100 %.
No comments:
Post a Comment