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 |
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
What is bi?
What are the methodologies of data warehousing?
How are the dimension tables designed?
What is source qualifier?
Give me a broad concept of what a data warehouse is, and what it might be used for?
Why fact table is in a normal form?
What are the different types of fact tables used in data warehousing?
What is the difference between datawarehouse and bi?
Where the data cube technology is used?
What are the different types of schemas used in data warehousing?
Explain me what are data marts?