Basics - What are Aggregate tables

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Go To First | Previous Question | Next Question

Basics | Question 8 of 111

What are Aggregate tables

Total Answers and Comments: 3

Last Update: October 04, 2005

Sponsored Links

Best Rated Answer

—

Submitted by: senkumar79

Aggregate table contains the summary of existing warehouse data which is grouped to certain levels of dimensions.Retrieving the required data from the actual table, which have millions of records will take more time and also affects the server performance.To avoid this we can aggregate the table to certain required level and can use it.This tables reduces the load in the database server and increases the performance of the query and can retrieve the result very fastly.

Above answer was rated as good by the following members:
ankeshjain

June 01, 2005 16:01:06

sireesha

RE: What are Aggregate tables

Aggregate tables contain redundant data that is summarized from other data in the warehouse.

Is this answer useful? Yes | No

June 28, 2005 07:45:16

Prabhu B

RE: What are Aggregate tables

These are the tables which contain aggregated / summarized data. E.g Yearly, monthly sales information. These tables will be used to reduce the query execution time.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

October 04, 2005 01:34:04

senkumar79

Member Since: October 2005 Contribution: 17

RE: What are Aggregate tables

Aggregate table contains the summary of existing warehouse data which is grouped to certain levels of dimensions.Retrieving the required data from the actual table, which have millions of records will take more time and also affects the server performance.To avoid this we can aggregate the table to certain required level and can use it.This tables reduces the load in the database server and increases the performance of the query and can retrieve the result very fastly.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top