what is the difference b/w star and snowflack schema in
dataware house?

Answer Posted / thava

Star schema is one fact table in the middle is sorrounded
by many dimension tables and no extenssion for the dimensin
table it means denormalized.
Snowflake schema is where the dimension table is extended
to normalized form

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how many reports have u created ? explain a few.

1655


what is the difference b/w the refresh and buffered data?

1757


Explain what are the steps to be taken to schedule the report?

631


What Is Snow Flake Schema?

664


how to create reports on screech?

2068






Differences between business objects and web intelligence reports?

649


how to prepare the documentation in business objects and where to get the requirement?

1776


explain in detail about type 3?

617


What is object stores?

578


How many universes can be created in a project?

591


What is a bo repository?

586


what will be the contents for a functional requirements specifications

1776


Explain what would you consider as your biggest achievement and why?

569


U r project in which stage in implementation?

1944


Explain when to use local filter and when to use global filter?

592