Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Regarding Star schema to a single table

Hello Friends,

I am new to QlikView, can we convert star schema to one table in QlikView, if so why and if not even why?

please let me know.

Thank you in advance.

Jeevi

1 Solution

Accepted Solutions
Siva_Sankar
Honored Contributor

Re: Regarding Star schema to a single table

DM.JPG

10 Replies
devarasu07
Honored Contributor II

Re: Regarding Star schema to a single table

Hi Jeevi,

It's depends upon your Business requirement and volume of your data. I would suggest to go with Star Schema model always because Star schema will usually result in the best performance for Qlikview applications.

Star Schema Emphasizes deep dive to check for different combinations by facilitating quick analytics in terms of query performance.

The reason why i don't go for Flat table can be a real nightmare to query against huge volumes of data.

In simpler words, Star Schema is as comfortable as having a Kitchen,DiningRoom,Bedroom,DrawingRoom,Bathroom etc in house rather having a single room for everything. Data FETCH becomes easier in Star Schema.

Hope this help you

Regards,

Deva

Siva_Sankar
Honored Contributor

Re: Regarding Star schema to a single table

Not applicable

Re: Regarding Star schema to a single table

Thank you so much guys, I appreciate your time!

Jeevi

Siva_Sankar
Honored Contributor

Re: Regarding Star schema to a single table

DM.JPG

Not applicable

Re: Regarding Star schema to a single table

Thank you!

ahaahaaha
Honored Contributor

Re: Regarding Star schema to a single table

Hi Jeevi,

Normalization of the structure of tables, ie. transition from one table to several related tables, is used to avoid duplication of data. This reduces the amount of memory used in the computer's memory. Accordingly, merging the data of several tables into one results in an increase in occupied memory due to the appearance of duplicate data.

There are no strict rules for organizing the structure of data tables, there are best practices and recommendations. With small amounts of data it does not really matter which of the two options to use.

Regards,

Andrey

oknotsen
Honored Contributor III

Re: Regarding Star schema to a single table

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post).

If not, please make clear what part of this topic you still need help with .

May you live in interesting times!
Not applicable

Re: Regarding Star schema to a single table

Thank you Andrey!

Highlighted
Partner
Partner

Re: Regarding Star schema to a single table

Can anybody explain why Single Table is bad for RAM Consumption and Script Run Time?