when we go for snow flake schema rather than star schema ?
Answer Posted / murali
snow flake schema is used for the dim tables contains more fields and the Dim_DB Tables are in the Normalization form.
Draw-back: Slow performance for executing the query.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
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
What are the join problems comes appart from loop,chasm & fan Traps
Did you face any problems while creating reports? Name? Solutions?
What are the steps to be taken to schedule the report?
What is the difference in creating filters in designer and business objects?
Explain what is the difference between slice and dice and cross tab report?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
what are the day to day activities of BO administrator ?
What is package in BO
What is difference between custom hierarchy and report based hierarchy?
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
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
How to create Index to the table in the universe designer and how it improves the Query performence
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
U r project in which stage in implementation?