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
What is difference between webi and infoview?
Can you please send me the migration related issues .
(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.
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
What is a bo repository?
What is the difference between the public object&schema object?
What is the difference between absolute and relative div positioning?
Can we Save (save as) WEBI Doc as DESKI?
What we need to discuss with designer before starting the universe designing.
What is difference between custom hierarchy and report based hierarchy?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
Explain about a tricky situation for which you found a very simple solution?
Explain is there any default username & pwd for bo designer & supervisor?
Differences between business objects and web intelligence reports?
What is a fantrap in business objects?