Interested to Buy Any Domain ? << Click Here >> for more details...
please differentiate star schema and snow fleak schema
with dimension table, how end user is depending on them in
creating reports.
- 1 Answers
- 5364 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
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 is there any other repository domains rather than universe, security, document?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain in detail about type 2(scd),
What is package in BO
Give some information on report bursting?
Explain about a task that really tested your analytical abilities?
Explain what would you consider as your biggest achievement and why?
What is the difference between slice and dice and cross tab report?
What are the data types present in bo? What happens if we implement view in the designer and report?
Explain what is the difference between slice and dice and cross tab report?
What is report template in b.o?
how to create metric universe ?
