Each Data Warehouse may differ in their size, scope, or complexity, there are certain fundamental themes that they all share.
The three important themes that all data warehouses share are -
- Processing time (Or) Handling Time
- Drilling down
- Drilling up
If a system has all of these factors, and it runs with a high level of efficiency, it can be truly called a data warehouse.