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
- 12278 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
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
How to execute the plsql procedure from the report by clicking with mouse?
Explain what are the measure objects?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
Differences between business objects and web intelligence reports?
Explain about a task that really tested your analytical abilities?
What is the difference between the public object&schema object?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
Can anybody tell me what are the tuning problems?
Explain is there any other repository domains rather than universe, security, document?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
How were the reports scheduled and how to resolve unexecuted documents?
