TableView Model - Star Or Snowflake - Does It Matter?

[rebelfox]

Hi,

I am starting to get to grips with QlikView.

I have a query over the TableView and the logical data view.

I have a book that states you should always try for a Star structure.

Yet many examples I see on sites such as this use snowflake structure.

It is fair to say aim for a star structure but don't get hung up on it and snowflake structure is still an acceptable solution?.

[maxgro]

there are a lot of post on the same questio

IMHO it doesn't matter

for difference, see the image

[Clever_Anjos]

Further reading; https://community.qlik.com/blogs/qlikviewdesignblog/2015/01/19/number-of-hops

[rebelfox]

Thanks.

I have the same diagram in the book I am working from but being an over-through perfectionist I was tunnel visioning myself down the Star Schema route.

I have decided it is best practice to have Star Schema but not essential and to always balance the benefits with the pressures of time etc.  Obvious I suppose when you think about it.