WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN
UNIVERSE?
Answer Posted / guru
If your universe has multiple star schema, having more than
1 fact table is natural. The issue, however, is when we
have more than 1 fact table in one star schema formation
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Explain about a tricky situation for which you found a very simple solution?
What is the difference between absolute and relative div positioning?
in sap bi we have wad, then why we go for sap bo
Explain what is the difference between slice and dice and cross tab report?
Explain about alerts in bos, under what situation we need to use alerts?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
8. How much supervision have you typically received in your previous job?
how to prepare the documentation in business objects and where to get the requirement?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
how to create metric universe ?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
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...
What Is Snow Flake Schema?
Give some information on report bursting?