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

List Price: $45.00 Discount Price: $25.71

Customer Reviews:

Another tool in the shed [Posted on 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.

Good for anyone who wants to Learn ETL [Posted on 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.

ETL Toolkit [Posted on 2007-10-30]
A great basic tool book for datawarehousing and ETL. I've purchased for my teams here and in India.

The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning [Posted on 2008-01-24]
The book was mailed well within time mentioned by seller and is a new book.

Another Kimball Toolkit [Posted on 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.

Click here for more details and discount information...