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

The data warehouse etl toolkit shows data warehouse developers how to effectively manage the etl (extract, transform, and load) phase of the data warehouse development lifecycle. The authors show developers the best methods for extracting data from scattered sources throughout the enterprise, removing obsolete, redundant, and inaccurate data, transforming the remaining data into correctly formatted data structures, and then physically loading them into the data warehouse. · requirements, realities, and architecture · data flow · implementation and operations · real time streaming etl systems