-------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


Please Help Members By Posting Answers For Below Questions

What is meant by Reportstudio shortcut?

1801


what is power prompt in cognos ep7series?what is the use of this?

3298


-----------With out using DrillThrough how to do Reports?

1679


What do you understand by the term 'dynamic cube'?

651


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?

2170






------------------What is Inline Query?

1876


How to deploy from one server to another server?

2103


How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?

2916


What do you understand by the cognos?

619


Can you define slice?

704


What is an olap designer?

626


is cognos 7 is better than cognos 8

1767


difference between impromptu and cognos8

2070


Explain about scorecarding?

1704


What is meant by drill down?

615