What is mean by aggregate aware?
How we are using this function?
Submitted by: AdministratorAggregate 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online BO Designer Job Interview Questions And Answers
Top BO Designer Questions
☺ | What is index awareness in universe? |
☺ | Could any one explain me how to create cascading prompts? |
☺ | What are steps we have to follow in designing the userfriendly Universe? |
☺ | How do we design a universe? |
☺ | How to create Universe using Flat file in BO6.0? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |