Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

i have totsl 5 cr records in all fact and dimension tables?

hen I create star schema datamodel with above records and

par allay I created snow flake schema datamodel  also

which application will be big size ?

star schema datamodel or snowflake schema ?

whether number of rows will  be same in  both dashboards ?

is there any rows difference because of star schema datamodel and snow flake schema data model ?

2 Replies
Highlighted
Specialist II
Specialist II

Re: i have totsl 5 cr records in all fact and dimension tables?

Highlighted
MVP & Luminary
MVP & Luminary

Re: i have totsl 5 cr records in all fact and dimension tables?

Hi,

The data size doesn't depend only on the numbers of records, it also take numbers of column, plus it also takes into account the visualisation.

Now About the schema's, There wont be any change in the numbers of records unless you have done wrong joins of the tables.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".