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
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
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?
What is difference between custom hierarchy and report based hierarchy?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
What is report template in b.o?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
What are the steps to be taken to schedule the report?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Explain what sort of existing documents should business analysts refer to when starting on a new project?
What would you consider as your biggest achievement and why?
what are the day to day activities of BO administrator ?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.