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

Answer Posted / raghu_nvs

Hi,
Star schema means centralized fact table joined with
different dimension tables.
snow flake schema means centralized fact table joined with
diff dimension tables, and again that dimension tables
joined with another dimension tables.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain which versions are used in the bo dashboard work?

629


Give some information on report bursting?

562


(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.

992


How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4308


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

595






Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

1614


8. How much supervision have you typically received in your previous job?

1824


can anybody tell me about complicated object you have created

2747


Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

1565


What are the steps to do to use alerts in bo?

625


Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

583


Explain how we drill up week to month?

635


Explain is there any other repository domains rather than universe, security, document?

576


What is the difference between condition & filter?

600


What is package in BO

2679