Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference b/w star and snowflack schema in
dataware house?
- 8 Answers
- 11682 Views
- I also Faced
- E-Mail Answers
Answer Posted / sreenivas
Star Schema : Star Schema is a relational database schema
for representing multimensional data. It is the simplest
form of data warehouse schema that contains one or more
dimensions and fact tables. It is called a star schema
because the entity-relationship diagram between dimensions
and fact tables resembles a star where one fact table is
connected to multiple dimensions. The center of the star
schema consists of a large fact table and it points towards
the dimension tables. The advantage of star schema are
slicing down, performance increase and easy understanding of
data.
Snowflake Schema : A snowflake schema is a term that
describes a star schema structure normalized through the use
of outrigger tables. i.e dimension table hierachies are
broken into simpler tables.
In a star schema every dimension will have a primary key.
# In a star schema, a dimension table will not have any
parent table.
# Whereas in a snow flake schema, a dimension table will
have one or more parent tables.
# Hierarchies for the dimensions are stored in the
dimensional table itself in star schema.
# Whereas hierachies are broken into separate tables in snow
flake schema. These hierachies helps to drill down the data
from topmost hierachies to the lowermost hierarchies.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
what is the difference b/w the refresh and buffered data?
What are the data types present in bo? What happens if we implement view in the designer and report?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
What are the steps to do to use alerts in bo?
Explain how to schedule the report in b.o?
Explain the difference between union and group?
How to generate the report from excel sheet?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
How we drill up week to month?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
Explain about a tricky situation for which you found a very simple solution?
What is the difference between the public object&schema object?
8. How much supervision have you typically received in your previous job?
Explain the data types present in bo and what happens if we implement view in the designer and report?
Explain is there any default username & pwd for bo designer & supervisor?
