The Data Warehouse ETL Toolkit Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data

Designing and building an ETL system for a data warehouse is an exercise in keeping perspective. This is a typical complex undertaking that demands a comprehensive plan up front. It’s easy to start transferring data from a specific source and immediately populate tables that can be queried. Hopefully, end users don’t see the results of this prototype because such an effort doesn’t scale and can’t be managed.