Series: Subject: Topic:
Question: 128 of 135

What are Aggregate tables

Asked by: Interview Candidate | Asked on: Jun 28th, 2005
Showing Answers 1 - 5 of 5 Answers

Answered On : Jun 1st, 2005

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

Login to rate this answer.
Prabhu B

Answered On : Jun 28th, 2005

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.

Yes  1 User has rated as useful.
Login to rate this answer.

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.

Yes  3 Users have rated as useful.
Login to rate this answer.

Aggregate table contains the summary of existing warhouse data , it contains data which is group accordingly (month , quartely etc) depending upon the business needs.For example you may contain transaction in fact table for all the customers but sometime you want the sum of amount for a particular customer over a month in that case you need to run the query in fact table which contains millions of row and time consuming. so avoid this problem we do the aggregation of amount in aggregate over a month for each customers, so this will improve the performance and you can retrieve the result very fastly.

Login to rate this answer.

Answered On : Aug 30th, 2010

View all answers by kevin0209

Aggregate table contains summarised data. The materialized view are aggregated tables.

Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions



twitter fb Linkedin GPlus RSS


Interview Question

 Ask Interview Question?


Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.