Question: what is the difference between a data warehouse and a transactional database?
Answer: Databases efficiently store transactional data, making it available to end users and other systems. Data warehouses aggregate data from databases and other sources to create a unified repository that can serve as the basis for sophisticated reporting and analytics.