please differentiate star schema and snow fleak schema
with dimension table, how end user is depending on them in
creating reports.
Answer Posted / padmalatha0923
star schema: it can be defined as a fact table sorrounded dy dimension tables and all the dimension tables should be de-normalised
snow flake schema: it can be defined as fact tables sorrunded by dimension tables and those dimension tables atleast one dimension table should be normalised
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Explain what task is 98% of the required work of a business analyst?
Explain what is the difference between business requirement document and use case document.
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
What is the difference between slice and dice and cross tab report?
In banking domain how many Fact tables,Dimension table are present?
Explain is there any default username & pwd for bo designer & supervisor?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
Explain what are the steps to be taken to schedule the report?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
What is the profile and package?
how to prepare the documentation in business objects and where to get the requirement?
what will be the contents for a functional requirements specifications
Explain about alerts in bos, under what situation we need to use alerts?