topic Re: Star Schema or Snow Flaxe schema? in QlikView

Star Schema or Snow Flaxe schema?

Sat, 28 Dec 2013 13:38:05 GMT

Hi All,

Which one best design approach, when creating data model using star schema or snowflake schema, which one give best performance in QlikView?

Sat, 28 Dec 2013 13:45:13 GMT

Hi,

Star scheme give you better performance. It includes better response time, script run time and data model is more flexible.

Sat, 28 Dec 2013 13:50:40 GMT

Hi,

Generally Olap servers using star schema and it's provide better performance .

Sat, 28 Dec 2013 17:04:31 GMT

Star schema gives better results especially for qlikview.why because if there is less no of joins qlikview works faster .

Sat, 28 Dec 2013 17:10:57 GMT

Hi,

check the below table it will be helpful to u

Sun, 29 Dec 2013 01:56:15 GMT

Hi,

To Check the below attachment copy also.it will helpful to you.

ngulliver — Tue, 21 Jan 2014 10:23:50 GMT

Hi,

Please have a look at this blog on perfecting your data model.

Regards,

Neil