Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Thank you so much guys, I appreciate your time!
Jeevi
Thank you!
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
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 .
Thank you Andrey!
Can anybody explain why Single Table is bad for RAM Consumption and Script Run Time?