please differentiate star schema and snow fleak schema
with dimension table, how end user is depending on them in
creating reports.
- 1 Answers
- 4656 Views
- Exilant, Wipro, I also Faced
- E-Mail Answers
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
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
how to create metric universe ?
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?
What are the steps to be taken to schedule the report?
What is the difference between business requirement document and use case document.
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
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 as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Explain what three things do you consider to be the most important factors for a manager?
in sap bi we have wad, then why we go for sap bo
Which command using Query Analyzer will give you the version of SQL server and operating system ?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
When to use local filter and when to use global filter?
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
