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.

1669


what are the day to day activities of BO administrator ?

1980


Explain what sort of existing documents should business analysts refer to when starting on a new project?

612


How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

702


What three things do you consider to be the most important factors for a manager?

608






Explain what three things do you consider to be the most important factors for a manager?

559


Can more than 1 metric be applied on an analytic in business objects?

1664


What is the difference between the public object&schema object?

582


Can anybody tell me what are the tuning problems?

1597


How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

1897


explain in detail about type 3?

633


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

1789


what will be the contents for a functional requirements specifications

1796


Difference between b.o 5.1 and 6.1b?

655


What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2408