when we go for snow flake schema rather than star schema ?
Answer Posted / divya
Snow flake schema is used when there are hierarchies,where
as star schema is used when there is only one level and no
hierachies
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is difference between custom hierarchy and report based hierarchy?
what is xcelsius architecture?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
What sort of existing documents should business analysts refer to when starting on a new project?
what are the tables used in health care domain project and columns used in report?
What are the steps to do to use alerts in bo?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
What is aggregate table and aggregate fact table ... Any examples of both?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Explain is data mart?
Explain about a task that really tested your analytical abilities?
In banking domain how many Fact tables,Dimension table are present?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What are all difference between business objects 6.5 and xi r2?
How would you format some text using css to be verdana and bold?