Wednesday 26 August 2015

What is the difference between Subset ratio & Information Density?

Information density of the field, which indicates the percentage of rows that contain a non-null value 

Subset ratio, which shows the percentage of all distinct values for a field in the table compared to all the distinct values for that field in the entire data model. It is only relevant for key fields since they are present in multiple tables and do not all share the same value. 

Subset ratios can be used to easily spot problems in key field associations. 

For example, when the combined total of subset ratios for multiple tables is 100 percent, this may indicate that there are no matching keys between these tables.

Share this

0 Comment to "What is the difference between Subset ratio & Information Density?"

Post a Comment