-------What are the Adv of Star Schema and Snow Flake
Schema?
- 4 Answers
- 11920 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 all the types of indexes in Cognos?
How do you improve the performance of the Cognos Analytics report
What are all the types of report?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
Can you define drill across?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
Explain the difference between native sql and cognos sql?
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
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
What is a Cube?
Define report item?
What is defined as Cognos Impromptu?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
