The Data Warehouse ETL Toolkit

Name: The Data Warehouse ETL Toolkit
Author: Ralph Kimball

Practical Techniques for Extracting, Cleaning, Confirming, and Delivering Data

Specificaties

Paperback, 491 blz. | Engels

Wiley Computing | 1e druk, 2004

ISBN13: 9780764567575

Rubricering

Hoofdrubriek : Computer en informatica

Juridisch : Computer en informatica

Wiley Computing 1e druk, 2004 9780764567575

Verwachte levertijd ongeveer 9 werkdagen

53,21

In winkelwagen

Samenvatting

Cowritten by Ralph Kimball, the world's leading data warehousing authority, this book delivers real-world solutions for the most time- and labor-intensive portion of data warehousing-data staging, or the extract, transform, load (ETL) process. Delineates best practices for extracting data from scattered sources, removing redundant and inaccurate data, transforming the remaining data into correctly formatted data structures, and then loading the end product into the data warehouse. This book offers proven time-saving ETL techniques, comprehensive guidance on building dimensional structures, and crucial advice on ensuring data quality.

Specificaties

ISBN13:9780764567575

Taal:Engels

Bindwijze:paperback

Aantal pagina's:491

Uitgever:Wiley Computing

Druk:1

Hoofdrubriek:Computer en informatica

Inhoudsopgave

Acknowledgments.
About the Authors.
Introduction.

Part I: Requirements, Realities, and Architecture.
1: Surrounding the Requirements.
2: ETL Data Structures.

Part II: Data Flow.
3: Extracting.
4: Cleaning and Conforming.
5: Delivering Dimension Tables.
6: Delivering Fact Tables.

Part III: Implementation and operations.
7: Development.
8: Operations.
9: Metadata.
10: Responsibilities.

Part IV: Real Time Streaming ETL Systems.
11: Real-Time ETL Systems.
12: Conclusions.

Index.