hi

[#1]

can anyone help me to find out the difference between the STAR SCHEMA and SNOWFLAKE SCHEMA.

[ecolomer · Accepted solution]

You can see ...

Snowflake Schema vs Star Schema - Difference and Comparison | Diffen

[ecolomer]

more ...

Difference between Star & Snowflake Schema

[MarcoWedel]

star schema snowflake schema which schema usefull Qlikview?why ?

Re: Star schema or snowflake schema or flat file?

Star Schema

Star Schema or Snow Flaxe schema?

anybody knows what schema it is?

Re: Difference between Star Schema & Snow Flake Schema?

which schema is best for data modeling betwen star and snowflake?

[ashfaq_haseeb]

Hi,

Have a look at below posts

http://community.qlik.com/message/524541#524541

http://community.qlik.com/message/542932#542932

Regards

ASHFAQ

[sujeetsingh]

Marco, it is like you have given a lots of link for the concept..

Well go for the Ralph Kimbel data ware housing concepts.

It is the Black book for all such concepts.

[SunilChauhan]

snow flake                                                                star         

1.Normalize                                                              denormalized

2.fact-> dimension-> dimension                              fact-> dimension (centralized fact)

3.when select to find result                                         when select to find take shortest path( retrival faster)

     may take more time( comparatively slow

     retrieval)

4. more Ram Consumption                                        comparative less Ram

5. No duplicates                                                      duplicated data posiblility as merging tables

6. query response time is more                                  comparitavely less

7.  good for transaction dbs                                       Good for BI (where only select impressions)

[#8]

Please search in Google, you will enough material.

Hope by above answers your query is sorted.

Thanks!