Answered Questions

  • What is the difference between star flake and snow flake schema?

    Star Read Best Answer

    Editorial / Best Answer

    zahoorahmad  

    • Member Since Apr-2006 | Apr 12th, 2006


    Star Schema:

    Well in star schema you just enter your desired facts and all the primary keys of your dimensional tables in Fact table. And fact tables primary is the union of its all dimension table key. In star schema dimensional tables are usually not in BCNF form.

    SnowFlake:

    Its almost like starschema but in this our dimension tables are in 3rd NF, so more dimensions tables. And these dimension tables are linked by primary, foreign key relation.

    Wassim Saade

    • Nov 23rd, 2011

    Star flake schema's are snowflake schema's where only some of the dimension tables have been denormalized.
    Every star flake schema is also a snowflake schema.
    Not every snowflake schema is a starflake schema.
    A snowflake schema with all of its dimension tables normalized is not a starflake schema.