Interested to Buy Any Domain ? << Click Here >> for more details...
-------What are the Adv of Star Schema and Snow Flake
Schema?
- 4 Answers
- 13460 Views
- Bank Of America, I also Faced
- E-Mail Answers
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 are the special features in cognos reportnet?
5. Which type of report you build more, list, crosstab or chart and why?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
what are the dimensions that you have in your current project?list them?
What is called Cognos powerplay?
Define datastores in cognos?
how to merge 2 crosstabs thans
How do you improve the performance of the Cognos Analytics report
What are the roles defined by cognos platform?
Define the cognos reporting tool?
What is the difference between Standard and Metrics folder?
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
What is a Framework manager?
How to publish a package by running Java Script?
What is the difference between ‘macro’ and ‘prompt?
