Interested to Buy Any Domain ? << Click Here >> for more details...
-------What are the Adv of Star Schema and Snow Flake
Schema?
- 4 Answers
- 13703 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 |
What is meant by Reportstudio shortcut?
Hi, I got a requirement wehre in in a drill through report , in parent report i have a column of numbers on which i have to apply drill through to child report.The condition is in that column if the number ia not zero the drill through link should appear (i.e., 1 to 9) if its 0 or negative number link should not appear. How ? Help would be appreciated
what do you mean by parallel execution of query?
what are diff b/w cognos and business objects
Can we install cognos 8 on windwos xp sp3.......(and i like to use data base as sql server 2000.....is it preferable?)......... pls let meknow... thaks in advance...
What is a Cube?
What is the function of cognos dispatcher?
What are the different types of OLAP. Which one is Cognos Powercube?
What are various types of gateways in cognos?
what is mean by complex starschema ,star schemagrouping?
What is IQD?What is contained in IQD?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
Teradata 
