What are Aggregate tables?



What are Aggregate tables?..

Answer / Deepak Chaudhary

Aggregate tables store pre-calculated summaries of data from the fact table to improve query performance by reducing the need for costly and time-consuming calculations.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Warehouse General Interview Questions

If two relational tables are connected to sq trans, what are the possible errors it will be thrown?

1 Answers  


What is bi?

1 Answers  


What are the methodologies of data warehousing?

1 Answers  


How are the dimension tables designed?

1 Answers  


What is source qualifier?

2 Answers  


Give me a broad concept of what a data warehouse is, and what it might be used for?

2 Answers  


Why fact table is in a normal form?

1 Answers  


What are the different types of fact tables used in data warehousing?

1 Answers  


What is the difference between datawarehouse and bi?

1 Answers  


Where the data cube technology is used?

1 Answers  


What are the different types of schemas used in data warehousing?

1 Answers  


Explain me what are data marts?

1 Answers  


Categories