Chapter 8. Version Control for Data Warehousing

If your data warehouse server(s) failed catastrophically, how long would it take to redeploy the system into production?

If you discovered a critical defect in your production DW/BI system, how long would it take to revert to a previous version while you resolve the problem?

If you had to prove that what you had in production was the same as what you think is in production, how long would that take?

As with other mission-critical systems, it should take no more than a few days to rebuild your DW/BI system from scratch—including reconfiguring new servers and reloading data. The actual redeployment of your warehouse implementation (database schemas, ETL scripts, BI applications, etc.) should range ...

Get Agile Analytics: A Value-Driven Approach to Business Intelligence and Data Warehousing now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.