topic Re: star and snow in QlikView

star and snow

Sun, 16 Aug 2015 06:32:04 GMT

I have tables and i just loaded into with and i created data model with out using any joins.

here my doubt is which schema is faster i.e star or snow with out using any joins between the tables

Re: star and snow

swuehl — Sun, 16 Aug 2015 20:48:40 GMT

In general, less hops between tables needed to aggregate field values in expressions are performing better.

But there might be other aspects to think about, like memory consumption.

Have a look at this presentation for an introduction:

Best Practices in Data Modeling.pdf

Re: star and snow

qlikviewwizard — Mon, 17 Aug 2015 03:55:00 GMT

Hi Please check the following links:

Re: Star & snowflake schema‌

Re: WHat is star and snowflake schema?? ANd which is better regarding performance point of view. ??

Hope this will help you.

Re: star and snow

jagan — Mon, 17 Aug 2015 04:15:08 GMT

Hi,

Star Schema is the best, because there will be less number of joins involved. Check below links

Re: Re: Star schema or snowflake schema or flat file?

Re: star and snow

Anonymous — Mon, 17 Aug 2015 05:35:51 GMT

Hi,

Star Schema is the best option for your data model. Performance wise comparing to snow flake, Star schema is best.

Re: star and snow

Anonymous — Mon, 17 Aug 2015 05:40:24 GMT

Please go through this link:

Star Schema or Snow Flaxe schema?

Hope it will help!!

Re: star and snow

Mon, 17 Aug 2015 17:45:13 GMT

In my case I have three tables one fact and 2 dimenstion.the fact is connected to 2 dimenstion tables that is star.

another situation fact is connected to dimention and that dimention is connected to other dimention that is snow schma.

Here i didn't used any joins.in this situation which one faster.

Re: star and snow

qlikviewwizard — Mon, 17 Aug 2015 23:09:38 GMT

Both will work faster.

Re: star and snow

qlikviewwizard — Mon, 17 Aug 2015 23:10:04 GMT

Can you please attach your sample files?

Re: star and snow

Tue, 18 Aug 2015 05:28:59 GMT

If you have 2 or more dimension tables joining to link to Fact table, snowflake is what you're "forced" to implement.

In my experience, there is negligible performance differences, though "best practice" suggests Star is best, it's sometimes unavoidable to use a snowflake schema.

Re: star and snow

alibd225 — Tue, 18 Aug 2015 05:44:39 GMT

Star is best for Data model.