The Data warehouse ETL toolkit : practical techniques for extracting, cleaning, conforming, and delivering data

Author

• Kimball, Ralph

Additional Author(s)

• Caserta, Joe

Publisher

Indianapolis, Indiana: Wiley Publishing, Inc., 2004

Language

English

ISBN

0764567578

Series

Subject(s)

• DATA WAREHOUSING
• DATABASE DESIGN
• DATABASE MANAGEMENT

Notes

. . Index: p.467 - 491

Abstract

The extract, transform, and load (ETL) phase of the data warehouse development life cycle is far and away the most difficult, time-consuming, and labor-intensive phase of building a data warehouse. Done right, companies can maximize their use of data storage; if not, they can end up wasting millions of dollars storing obsolete and rarely used data. Bestselling author Ralph Kimball, along with Joe Caserta, shows you how a properly designed ETL system extracts the data from the source systems, enforces data quality and consistency standards, conforms the data so that separate sources can be used together, and finally delivers the data in a presentation-ready format.

Serving as a road map for planning, designing, building, and running the back-room of a data warehouse, this book provides complete coverage of proven, timesaving ETL techniques. Beginning with a quick overview of ETL fundamentals, it then looks at ETL data structures, both relational and dimensional. The authors show how to build useful dimensional structures, providing practical examples of techniques

Physical Dimension

Number of Page(s)

xxxiv, 491p.

Dimension

23 cm.

Other Desc.

-

Summary / Review / Table of Content

No summary / review / table of content available!

Exemplar(s)

#	Accession No.	Call Number	Location	Status
1.	05043/08	005.74 Kim D	Library - 7th Floor	Available
2.	00478/18	005.74 Kim D	Library - 7th Floor	Available