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
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
Explain how many universes can be created in a project?
What Is Snow Flake Schema?
How we drill up week to month?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
Explain about a tricky situation for which you found a very simple solution?
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...
What is the difference between slice and dice and cross tab report?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
Explain the difference between detect alias and detect context?
When we use aggregate awareness function in designer?
Explain about a task that really tested your analytical abilities?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?