BO Designer Question:
Download Job Interview Questions and Answers PDF
What is mean by aggregate aware?
How we are using this function?
Answer:
Aggregate awareness is a term that describes the ability of a universe to make use of aggregate tables in a database. These are tables that contain precalculated data. You can use a function called @Aggregate_Aware in the Select statement for an object that directs a query to be run against aggregate tables rather than a table containing non aggregated data.
Pros:
Speed up the execution of query and Improve the performance of Sql transaction.
If you are using the aggregate tables then you must refresh the aggregate table with all fact tables to have the consistency in your result.
Pros:
Speed up the execution of query and Improve the performance of Sql transaction.
If you are using the aggregate tables then you must refresh the aggregate table with all fact tables to have the consistency in your result.
Download BO Designer Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How do we design a universe? | what are templates in which way it is help full? what is data provider? what is freehand sql? difference between b.o 5.1 and 6.1b? |