Data Warehouse Manager Question:
Download Job Interview Questions and Answers PDF
Tell me what are Aggregate tables?
Answer:
Aggregate tables are the tables which contain the existing warehouse data which has been grouped to certain level of dimensions. It is easy to retrieve data from the aggregated tables than the original table which has more number of records.
This table reduces the load in the database server and increases the performance of the query.
This table reduces the load in the database server and increases the performance of the query.
Download Warehouse Manager Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain me what needs to be done when the database is shutdown? | Explain what is dimensional modeling? |