Help on schema

[Anonymous]

Hi

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

[jonathandienst]

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

[qlikmsg4u]

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?

[maxgro · Accepted solution]

snowflake