Interested to Buy Any Domain ? << Click Here >> for more details...
-------What are the Adv of Star Schema and Snow Flake
Schema?
- 4 Answers
- 13506 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 are shortcuts? Where it can be used? What are the advantages?
WHAT SHOULD BE DONE WHEN A REPORT RUNNING TIME WILL TAKE LONG TIME IN CONGNOS?
2 Answers ABC Infotech, Virtusa,
What is content Manager?
How create measures and dimensions?
can anybody send me interview questions with answers on IBM cognos-FM and Report studio. My mail ID is: cskcognos@gmail.com
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
9. What was the most complex type of report you dealt with?
7. What is performance tuning?
how can create a report like if the salary>50,000 display balance,if salary<50,000 display green?
how many types of variables in cognos report net and cognos 8
what use of surgate key in project
What is RenderVariable?
Teradata 
