Data Warehouse Etl Toolkit

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.

Table of contents :
Acknowledgments
About the Authors
Introduction

Part I: Requirements, Realities, and Architecture
· Surrounding the Requirements
· ETL Data Structures
Part II: Data Flow
· Extracting
· Cleaning and Conforming
· Delivering Dimension Tables
· Delivering Fact Tables

Part III: Implementation and Operations
· Development
· Operations
· Metadata
· Responsibilities

Part IV: Real Time Streaming ETL Systems.
· Real-Time ETL Systems
· Conclusions

Index




Market Description :
· Data Warehouse Developers and Administrators

About 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.