Data is periodically brought from the operational DBs into the data warehouse.
- Extract data from multiple sources, Change-Data Capture
- Transform - Data Cleaning, conform, deduplicate
- Load into the warehouse
Data is periodically brought from the operational DBs into the data warehouse.