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
- 12254 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
Explain what are the steps to be taken to schedule the report?
Can we configure two instances of CMS pointing to two different CMS system databases?
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,
Explain how to execute the plsql procedure from the report by clicking with mouse?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
What task is 98% of the required work of a business analyst?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
What is aggregate table and aggregate fact table ... Any examples of both?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
Is there any other repository domains rather than universe, security, document?
