Interested to Buy Any Domain ? << Click Here >> for more details...
-------What are the Adv of Star Schema and Snow Flake
Schema?
- 4 Answers
- 13666 Views
- Bank Of America, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / krishnakumari
Star Schema:
Definition: The star schema is the simplest data warehouse
schema. It is called a star schema because the diagram
resembles a star with points radiating from a center.
A single Fact table (center of the star) surrounded by
multiple dimensional tables(the points of the star).
Advantages:
Simplest DW schema
Easy to understand
Easy to Navigate between the tables due to less number of
joins.
Most suitable for Query processing
Disadvantages:
Occupies more space
Highly Denormalized
Snowflake schema:
Definition: A Snowflake schema is a Data warehouse Schema
which consists of a single Fact table and multiple
dimensional tables. These Dimensional tables are
normalized.A variant of the star schema where each
dimension can have its own dimensions.
Advantages:
These tables are easier to maintain
Saves the storage space.
Disadvantages:
Due to large number of joins it is complex to navigate
Starflake schema - Hybrid structure that contains a mixture
of (denormalized) STAR and (normalized) SNOWFLAKE schemas
| Is This Answer Correct ? | 10 Yes | 3 No |
Answer / harini
Better understanding of data is the main advantage of stake
flow schema in dw
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / vishwamitra
# 1 StarSchema Advantage: Slicing down,performance increase
and
easy to understand the data.
# 2 Star Schema:
Definition: The star schema is the simplest data warehouse
schema. It is called a star schema because the diagram
resembles a star with points radiating from a center.
A single Fact table (center of the star) surrounded by
multiple dimensional tables(the points of the star).
Advantages:
Simplest DW schema
Easy to understand
Easy to Navigate between the tables due to less number of
joins.
Most suitable for Query processing
Disadvantages:
Occupies more space
Highly Denormalized
Snowflake schema:
Definition: A Snowflake schema is a Data warehouse Schema
which consists of a single Fact table and multiple
dimensional tables. These Dimensional tables are
normalized.A variant of the star schema where each
dimension can have its own dimensions.
Advantages:
These tables are easier to maintain
Saves the storage space.
Disadvantages:
Due to large number of joins it is complex to navigate
Starflake schema - Hybrid structure that contains a mixture
of (denormalized) STAR and (normalized) SNOWFLAKE schemas
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / amp mohan
StarSchema Advantage: Slicing down,performance increase and
easy to understand the data.
| Is This Answer Correct ? | 3 Yes | 8 No |
I have Date,product,Quantity_Sold columns and I want Product, MTD(month Till date),YTD(Year Till Date) as output. Can anyone help me with the logic in getting MTD i.e quantity sold from 1st of this month to till date (i.e. 01- 11-2013 to 26-11-2013) and YTD i.e QTD sold from 1st date of the year to till date(i.e. 01-01-2013 to 26-11-2013). Sample output model: Product MTD YTD
What is the concept of using Dimension allocation "By Measure"? How Transformer use when computing the Base measue?
what are the components having in the report studio using interface eg:insertable objects pan,properties pan
What you mean by drill across and what is the difference between drill through, drill across?
how to solve many -many relations ship in frame work manager?and how to avoid cartigen product in frame work manager?
How do you call a store procedure within a transformation?
what is stitch query?
what are the uses of report studio,q.studio,analysis studio,event studio&.metric studi.
Suppose you have a report with no data , when you run the report in report studio how can you tell the end user , that it has no data , while he runs it?Is it possible ? if so how?
what does my folder and public folder contains? difference between the my folder and public folder?
How to findout YEAR CALCULATION? THAT MEANS YOU SHOW THIS YEAR REVENUE AND LAST YEAR REVENUE. WHEN YOU FILTER THIS YEAR VALUE THE RESULT SHOULD DISPLAY THIS YEAR RESULT AND LAST YEAR RESULT.
what are the limitations of cognos reportnet?
11 Answers IBM, Nestle, TCS,
Teradata 
