Aggregate tables are used to

Options
- Reduces memory requirement for data.
- Reduces loading time of data
- Reduces the load in the database server
- Reduces memory requirement on database server.

CORRECT ANSWER : Reduces the load in the database server

Discussion Board
Aggregate tables

Aggregate tables reduces the load on the database server. It contains redundant data that is summarized from other data in the warehouse. Aggregates are used in dimensional models of the data warehouse to produce dramatic positive effects on the time it takes to query large sets of data.

Prajakta Pandit 03-16-2017 06:26 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲