This content has been marked as final.
Show 4 replies

Re: Field Information  Subset ratio
Thirumala Dandamudi Aug 8, 2018 2:27 PM (in response to Jonathan Aighobahi)Check for Information Density and Subset Ratio
 Information density indicates the percentage of rows that contain a distinct value for a field.
 Subset ratio (only on key) 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.
Both indicators are paramount when verifying the data model. They indicate if the key chosen is a quality field between 2 tables. If there are no/little common values between the 2 tables, it means that the key cannot be used or that the key is not precise enough. It saves a lot of time and can be used to check a key before joining 2 tables.
https://www.element61.be/en/resource/professionaltestingqlikapplication
What is the difference between Subset ratio and information density.
Hope this helps..

Re: Field Information  Subset ratio
Pooja Nagaraj Aug 9, 2018 1:35 AM (in response to Jonathan Aighobahi)Hi,
Refer this link for more information.
information density and subset ratio? What is the use of this?
Thanks,
Pooja

Re: Field Information  Subset ratio
arvind pednekar Aug 9, 2018 1:44 AM (in response to Jonathan Aighobahi) Information density: This displays the percentage of rows in the table with values (none are null).
 Subset ratio: This displays the percentage of distinct values in this table for this data field (out of all possible distinct values for the data field contained in all tables).

Re: Field Information  Subset ratio
Jonathan Aighobahi Aug 10, 2018 11:51 AM (in response to Jonathan Aighobahi)Thanks everyone. The links and comments were very helpful. I have a better understanding of Subset ratio now.