Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
waszcma1
Partner - Creator II
Partner - Creator II

Density in data model viewer

Hi 

I am trying to optimize very slow application and what I have discover that in the fact table there are fields which have very low Density

 

  • Information Density is the number of records that have values (i.e. not NULL) in this field as compared to the total number of records in the table.

i.e.:

waszcma1_0-1628187292820.png

so it means that in ~26 mln records 48,4% have non null-value for that field? 

 

 

 

 

 

1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

No, it means that there are 26410575 non null values that are making up the 48,4%

So, total rows in table are ~26 mln in ~55 mln rows in table

View solution in original post

1 Reply
Lisa_P
Employee
Employee

No, it means that there are 26410575 non null values that are making up the 48,4%

So, total rows in table are ~26 mln in ~55 mln rows in table