Data Integration After The Fact

Data Integration After The Fact: "When building a new data warehouse, most companies concentrate on building a star schema as perfectly as possible. Once the data warehouse has been designed and built, you must usually build indexes to improve those queries that didn?t appreciate the beauty of the star schema. The Extract, Transform & Load (ETL) team focuses on getting the data out of the source systems and into the correct format for the data warehouse. It takes a great deal of trial and error to get the transforms right and validate all of the data. "