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.