The Data Vault Approach
When operational data arrives from multiple sources, then a data warehouse may be required to capture change and reconcile figures.
Millersoft practices building Data Warehouses using the Data Vault approach to ensure:
- Change Within the Data Warehouse is Easy and Encouraged
- Data Can Be Reconciled Directly with Operational Systems
- The Warehouse Can Scale
- Scope of Any Change is Limited
- Reduce Complexity and Time Needed to Generate Cubes