what is the difference b/w star and snowflack schema in
dataware house?
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
Explain how to execute the plsql procedure from the report by clicking with mouse?
U r project in which stage in implementation?
What is difference between custom hierarchy and report based hierarchy?
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
How many universes can be created in a project?
How would you format some text using css to be verdana and bold?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
Explain about a tricky situation for which you found a very simple solution?
What are all difference between business objects 6.5 and xi r2?
What is the difference between business requirement document and use case document.
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
what are the day to day activities of BO administrator ?
Explain is there any other repository domains rather than universe, security, document?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.