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
- 11892 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
How to schedule the report in b.o?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
What Is Snow Flake Schema?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Can Bo generates the Report from the cubical data Explain?
Explain what is the difference between slice and dice and cross tab report?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
How to open a universe with out using the Designer ??
Explain how to schedule the report in b.o?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
Explain about a task that really tested your analytical abilities?
Explain in detail about type 2(scd),
Explain what task is 98% of the required work of a business analyst?
Can you please send me the migration related issues .
