What is aggregate fact table?



What is aggregate fact table?..

Answer / Aditya Kumar Batham

An aggregate fact table is a type of data table in a data warehouse that stores summarized, pre-aggregated data. Instead of storing detailed transactional data, the aggregate fact table provides quick access to summary information for faster reporting and analysis. An example of an aggregate fact table might store monthly sales totals instead of individual sales transactions.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Warehouse General Interview Questions

Explain me what are data marts?

1 Answers  


Explain degenerate dimension table?

1 Answers  


What is MODEL is Data mining world?

1 Answers   Bank Of America,


What is meta data and system catalog?

1 Answers  


What is difference between e-r modeling and dimensional modeling?

1 Answers  


Data WareHousing course in noida

1 Answers  


Explain what is the advantages data mining over traditional approaches?

1 Answers  


State any 5 of Cods guidelines of an OLAP system, brief description each?

1 Answers  


what is hybrid schema

4 Answers   TCS,


For faster process, what we will do with the universe?

1 Answers  


What is a general purpose scheduling tool?

1 Answers  


What is the working process for application.cfm?

1 Answers  


Categories