topic Re: Help on schema in QlikView

Help on schema

Anonymous — Tue, 04 Aug 2015 08:21:40 GMT

How to find the whether it is star or snow flake schema by observing datamodel.I am attaching a datamodel ,please let me know whether it is star or snowflake.

I feel it is snowflake because dim tables are connected to each other but not to the fact .

please correct if i am wrong

Thanks

Re: Help on schema

jonathandienst — Tue, 04 Aug 2015 08:23:39 GMT

Technically this is a snowflake with a data island (disconnected table(s)) - but why does it matter?

Re: Help on schema

qlikmsg4u — Tue, 04 Aug 2015 08:24:28 GMT

It is snowflake schema,

1.When you have one Fact Table and Multiple Dimension Tables is a Star schema.

2.When You have a Fact Table it is connected to dimension table and then sub dimension table is a snow flake schema.

for more information please go through this

Difference between Star Schema & Snow Flake Schema?

Re: Help on schema

maxgro — Tue, 04 Aug 2015 08:36:46 GMT

snowflake