What is meant by Aggregate Factable?

Factable having aggregated calculations like sum, avg, sum(sal)+sum(comm),
these are Aggregated Factable



Cheers
Padhu
  • Interview Candidate
  • 3
  • 2923

Showing Answers 1 - 3 of 3 Answers

ThomasB

  • Jan 4th, 2008
 

An aggregate fact table stores information that has been aggregated, or summarized from a detail fact table.  Aggregate fact table ares useful in improving query performance. 

Often an aggregate fact table can be maintained through the use of materialized views, which, under certain databases, can automagically be substituted for the detailed fact table if appropriate in resolving a query.

Give your answer:

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

 

Related Answered Questions

 

Related Open Questions