Answered by Girinath.S.V.S on 2005-03-17 06:40:48: Snowflake schemas normalize dimensions to eliminate redundancy. That is, the dimension data has been grouped into multiple tables instead of one large table. For example, a product dimension table in a star schema might be normalized into a products table, a product_category table, and a product_manufacturer table in a snowflake schema. While this...

prodyot.sarkar

 Profile Answers by prodyot.sarkar Questions by prodyot.sarkar

• May 13th, 2010

Snow-flake schema is a logical arrangement of tables in dimensional modeling where a centralized fact table references number of other dimension tables; however, those dimension tables are further nor...

harshadapj

 Profile Answers by harshadapj Questions by harshadapj

• Jul 22nd, 2008

Closely related to the star schema, the snowflake schema is represented by centralized fact tables which are connected to multiple dimensionsIn the snowflake schema, however, dimensions are normalized...

Answer Question  Select Best Answer

Answer posted by Chintan on 2005-05-22 18:34:55: A relational database schema organized around a central table (fact table) joined to a few smaller tables (dimension tables) using foreign key references. The fact table contains raw numeric items that represent relevant business facts (price, discount values, number of units sold, dollar value, etc.)

kamesh

• Jan 30th, 2018

A join is linked with only one dimension and one fact is called Star chema

TimeBeing

• Jan 25th, 2017

A Fact table is surrounded by multiple Dimension tables and which is look like STAR in graphical design is called "STAR Schema".

Answer Question  Select Best Answer