The Data Warehouse ETL Toolkit

0.0

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. About The Author Ralph Kimball has been a leading visionary in the data warehousing industry since 1982 and one of today's best-known speakers and educators. He is the author of several of the best-selling titles ever published on data warehousing, including The Data Warehouse Toolkit 2nd edition (more than 92,000 copies in two editions). Joseph Caserta is founder of Caserta Concepts, LLC, a data warehousing consulting firm, with clients that include McKinsey & Company and Citibank. He writes frequently for print and online magazines, and is an active contributor to DWList, the major online community for data warehousing professionals. Table Of Contents Acknowledgments Introduction Part I: Requirements, Realities, and Architecture Surrounding the Requirements ETL Data Structures Part II: Data Flow Extracting Cleaning and Conforming Delivering Dimension Tables Part III: Implementation and Operations Development Operations Metadata Responsibilities Part IV: Real Time Streaming ETL Systems. Real-Time ETL Systems Conclusions Index