Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Start Schema or Single Table Schema. Which one is better?

Which one should be preferred while developing apps?

1 Solution

Accepted Solutions
Partner
Partner

The correct answer should be: "It depends"...

Please check the following posts:

Star Schema or Snow Flaxe schema?

Re: star & snowflake schema

And as a summary (from Mahesh T‌  reply on one of posts):

Untitled.png

Regards,

Vlad

View solution in original post

4 Replies
Creator
Creator

Hiii Vikraant,

Best practice is to have Star Schema in any data modelling.

Anyhow, if you can make all the tables in one fact table the performance will be much faster for the developing application.

Regards,

Mahesh Shetty

Partner
Partner

The correct answer should be: "It depends"...

Please check the following posts:

Star Schema or Snow Flaxe schema?

Re: star & snowflake schema

And as a summary (from Mahesh T‌  reply on one of posts):

Untitled.png

Regards,

Vlad

View solution in original post

Creator III
Creator III

Hi Vikraant,

Based on requirement, mostly we can use star schema.

If we can able to merge the Dimension tables into one fact table its best for performance, but so many projects not possible these one tats the reason we are using star and snowflake.


Regards

Sathish

Creator III
Creator III

Hi Vikrant,

if any one answer is ok to you please mark correct and close the thread.

Regards

sathish