Learn How to Do-It-Yourself!
  Search:       

The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin

by Ralph Kimball, Joe Caserta

List Price:$45.00
Amazon Price:$39.33 & eligible for FREE Super Saver Shipping on orders over $25.
You Save:$5.67 (13%)
Average Rating:5 out of 5 stars
Lowest New Price:$26.07
Availablitiy:Usually ships in 24 hours

Buy Now!


Editorial Reviews
Product Description
* 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


All Customer Reviews
Average Customer Review:5 out of 5 stars
0 of 0 people found the following review helpful:

5 out of 5 starsAnother Kimball Toolkit, 2008-05-09
In my estimation The Data Warehouse ETL Toolkit is a good source of information for the topic that covers the majority of your Data Warehouse efforts, the ETL process (or ECCD if you prefer, which you probably will after finishing this volume). I took away some good ideas on items that I probably would not have considered, mostly due to my own ignorance, relating to Meta Data, QA and Error Corrections, Data Lineage and Scoring, etc.

The Authors (Kimball and Caserta) do a good job of pointing out other source books for items that the user will probably want to look at in depth.

There is also a pretty good section explaining how to manage your ETL project, the different roles of people who should be involved and a pretty good project plan / checklist to use as you are getting started.

My only complaint is that I did not read this prior to starting my own project and am instead having to correct items as I try to implement these best practices.


0 of 1 people found the following review helpful:

5 out of 5 starsThe Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, 2008-01-24
The book was mailed well within time mentioned by seller and is a new book.


0 of 0 people found the following review helpful:

5 out of 5 starsETL Toolkit, 2007-10-30
A great basic tool book for datawarehousing and ETL. I've purchased for my teams here and in India.


2 of 2 people found the following review helpful:

4 out of 5 starsGood for anyone who wants to Learn ETL, 2007-10-05
This book gives practical guidelines to follow through the ETL cycle, it does not matter if you are using an Industry Standard ETL tool or writing your own ETL process from scratch, this book will be useful for both. I found it very useful. Definitely worth a read for anyone who is new to ETL.


0 of 1 people found the following review helpful:

5 out of 5 starsAnother tool in the shed, 2007-08-01
This is a very good book from the Data Warehouse toolkit series by Ralph Kimball et al. This one is all about ETL - extract, transform and load, although the authors may put it a little bit different sometime:

[quote]
We expand the traditional ETL steps of extract, transform, and load into the more actionable steps of extract, clean, conform, and deliver, although we resist the temptation to change ETL into ECCD!
[/quote]

Anyhow, ETL or ECCD, it's the same thing - fetching the data from your live operational systems and putting it in your data warehouse.

The book thoroughly covers the entire ETL process. Believe me, I tried to squeeze a digest here. A few times. It goes out of hand. A lot, a huge lot of all sorts of information. Useful, extensive, clear and interesting to read.

Having read the first (?) book in the series - The Complete Guide to Dimensional Modeling -
helps greatly in understanding, because this book uses the same (standard) terminology - dimensions, facts, and so on.

Probably the only thing to whine about is the pictures. They could have definitely been better. Some of them are cryptic and some of them have no real value. Let's put it this way - some of the pictures do not help.

Anyhow, great book.




Price is accurate as of the date/time indicated. Prices and product availability are subject to change. Any price displayed on the Amazon website at the time of purchase will govern the sale of this product.
Related Products