-------What are the Adv of Star Schema and Snow Flake
Schema?
Answer Posted / 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 |
Post New Answer View All Answers
What is meant by Reportstudio shortcut?
what is power prompt in cognos ep7series?what is the use of this?
-----------With out using DrillThrough how to do Reports?
What do you understand by the term 'dynamic cube'?
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
------------------What is Inline Query?
How to deploy from one server to another server?
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
What do you understand by the cognos?
Can you define slice?
What is an olap designer?
is cognos 7 is better than cognos 8
difference between impromptu and cognos8
Explain about scorecarding?
What is meant by drill down?