Star Schema or Snow flow Schema

[#1]

Hi Good Morning....

I have small Confusion between Star Schema and Snow Flow Schema..

Which one is better?

Thanks In Advance....

[#2]

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

check the below table it will be helpful to u

[#3 · Accepted solution]

Chek the below link.i hope this helps u alot.

Star Schema or Snow Flaxe schema?

[#4]

Thank you

[#5]

Star Schema is better because of

1. Has redundant data and hence less easy to maintain/change
2. Less complex queries and easy to understand
3. Less no. of foreign keys and hence lesser query execution time
4. Good for datamarts with simple relationships (1:1 or 1:many)
5. Fewer Joins
6. Contains only single dimension table for each dimension

[#6]

Thank u