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

by ;
Edition: 1st
Format: Paperback
Pub. Date: 2004-10-01
Publisher(s): WILEY
  • Free Shipping Icon

    This Item Qualifies for Free Shipping!*

    *Excludes marketplace orders.

List Price: $53.76

Buy New

Arriving Soon. Will ship when available.
$51.20

Rent Textbook

Select for Price
There was a problem. Please try again later.

Rent Digital

Rent Digital Options
Online:1825 Days access
Downloadable:Lifetime Access
$45.60
$45.60

Used Textbook

We're Sorry
Sold Out

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

Cowritten by Ralph Kimball, the world's leading data warehousing authority, whose previous books have sold more than 150,000 copies 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 Offers proven time-saving ETL techniques, comprehensive guidance on building dimensional structures, and crucial advice on ensuring data quality

Author Biography

RALPH KIMBALL, PhD, founder of the Kimball Group, has been a leading visionary in the data warehousing industry since 1982 and is one of today’s best-known speakers and educators. He is the author of several bestselling titles published on data warehousing, including The Data Warehouse Toolkit (Wiley).

JOE CASERTA is the founder of Caserta Concepts, LLC, a data warehousing consulting firm. 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

Introduction.
Overview of this Book: Two Simultaneous Threads.
The Planning and Design Thread.
The Data Flow Thread.
How The Book Is Organized.
Who Should Read this Book.
PART I: REQUIREMENTS, REALITIES, AND ARCHITECTURE.
Chapter 1. Surrounding the Requirements.
Chapter 2. ETL Data Structures.
PART II: DATA FLOW.
Chapter 3. Extracting.
Chapter 4. Cleaning and Conforming.
Chapter 5. Delivering Dimension Tables.
Chapter 6. Delivering Fact Tables.
PART III: IMPLEMENTATION AND QUESTIONS.
Chapter 7. Development.
Chapter 8. Operations.
Chapter 9. Metadata.
Chapter 10. Responsibilities.
PART IV: REAL TIME STREAMING ETL SYSTEMS.
Chapter 11. Real Time ETL Systems.
Chapter 12. Conclusions.
 

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.