1.

What Are Aggregate Awareness And Index Awareness? Where Are They Used And How Can Be Used?

Answer»

Aggregate Awareness:

  • INFORMATION is persisted in database as a summary form.
  • The data warehouse stores the quantity of data each hour / day / week.

AGGREGATIONS are USED 

  1. To save the space of storage media.
  2. To improve the performance of BI tool – QUERIES takes less time to PROCESS, thus users obtain the information quickly.

Index Awareness:

  • The ability to take the advantage of the indexes of key columns for quick data retrieval.
  • Set up the Index awareness in BO Designer by specifying the database primary and foreign key columns.
  • SQL is generated by the BO Designer, for filtering the most efficient way, by using Index Awareness.

Aggregate Awareness:

Aggregations are used 

Index Awareness:


Discussion

No Comment Found

Related InterviewSolutions