Interested to Buy Any Domain ? << Click Here >> for more details...
main purpose of aggregate awareness(not include make
possible of use of aggregate tables)
- 2 Answers
- 8366 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / sai
Aggregate tables are used in the schema in oreder to
inprove the query performance.it is implemented by using
@aggregate_aware()function.these tables carries
precalculated aggregates(measures).it will improve query
performane,so we will get data fastly.refer this link to
know more:
http://www.dwoptimize.com/2007/09/aggregate-awareness.html
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
What would you consider as your biggest achievement and why?
Explain the difference between union and group?
8. How much supervision have you typically received in your previous job?
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 what sort of existing documents should business analysts refer to when starting on a new project?
How to execute the plsql procedure from the report by clicking with mouse?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain which versions are used in the bo dashboard work?
Explain what task is 98% of the required work of a business analyst?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
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
Which versions are used in the bo dashboard work?
in sap bi we have wad, then why we go for sap bo
Explain is data mart?
Explain how we drill up week to month?
