what is the difference b/w star and snowflack schema in
dataware house?
Answer Posted / thava
Star schema is one fact table in the middle is sorrounded
by many dimension tables and no extenssion for the dimensin
table it means denormalized.
Snowflake schema is where the dimension table is extended
to normalized form
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
how to create reports on screech?
What Is The Difference Between Oltp And Olap?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Explain about a task that really tested your analytical abilities?
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
Explain how to schedule the report in b.o?
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?
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
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:
How to generate the report from excel sheet?
Explain when we use aggregate awareness function in designer?
What is difference between custom hierarchy and report based hierarchy?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What are the data types present in bo? What happens if we implement view in the designer and report?
What is the difference between condition & filter?