In short
A data warehouse is a central repository of cleaned, integrated historical data copied from operational systems and organized for reporting and analysis.
Key takeaways
- It keeps analysis separate from day-to-day transaction processing.
- Data is structured before it is loaded; a data lake stores raw data in its native format.
- Extract, transform and load processes feed it, and need controls over completeness and accuracy.
Where it's tested
ISC: Information Systems Fundamentals — study notes, a five-minute revision sheet and practice questions.
Practise: 3 questions
Question 1 of 3 · 0 answered
A company copies historical data from its operational systems into a separate repository, organized for reporting and analysis across several years. This repository is a: