Interested to Buy Any Domain ? << Click Here >> for more details...
what is aggregate navigation?
- 3 Answers
- 26951 Views
- Countrywide, CTS, HCL, I also Faced
- E-Mail Answers
Answer Posted / sam
To receive the performance benefit offered by an aggregate
schema, a query must be written to use the aggregate.
Rewriting the sample query was a simple matter of
substituting the name of the aggregate fact table for that
of the base fact table. This may be easy for technical
personnel, but can prove confusing for an end user. The
complexity grows as additional aggregate tables are added.
Technical and business users alike may err in assessing
which table will provide the best performance. And, if more
aggregate tables are added or old ones removed, existing
queries must be rewritten.
The key to avoiding these pitfalls lies in implementation
of an aggregate navigator.
A component of the data warehouse infrastructure, the
aggregate navigator assumes the task of rewriting user
queries to utilize aggregate tables.
Users and developers need only be concerned with the base
schema. At runtime, the aggregate navigator redirects the
query to the most efficient aggregate schema.
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
Explain is there any default username & pwd for bo designer & supervisor?
What is top business?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
Explain about a time when you discovered a more efficient way to do a work task?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
In banking domain how many Fact tables,Dimension table are present?
Explain how we drill up week to month?
What Is Snow Flake Schema?
How to schedule the report in b.o?
Explain is there any other repository domains rather than universe, security, document?
Which versions are used in the bo dashboard work?
Can we Save (save as) WEBI Doc as DESKI?
explain in detail about type 3?
