what is the difference b/w star and snowflack schema in
dataware house?
Answer Posted / simha
i think ur answer is swap to both. star is
denormalised,snowflake is normalised.
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
Explain about a tricky situation for which you found a very simple solution?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
(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.
Explain the difference between union and group?
what are the tables used in health care domain project and columns used in report?
How we drill up week to month?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
Can anybody tell me what are the tuning problems?
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
Did you face any problems while creating reports? Name? Solutions?
What is the difference between slice and dice and cross tab report?