No es necesario ningún dispositivo Kindle. Descárgate una de las apps de Kindle gratuitas para comenzar a leer libros Kindle en tu smartphone, tablet u ordenador.

  • Apple
  • Android
  • Windows Phone
  • Android

Obtén la app gratuita:

Precio lista ed. digital: EUR 43,56
Precio Kindle: EUR 30,49

Ahorra EUR 19,82 (39%)

IVA incluido (si corresponde)

Estas promociones se aplicarán a este artículo:

Algunas promociones pueden combinarse; otras no. Para más detalles, revisa los términos y condiciones de cada promoción.

Enviar a mi Kindle o a otro dispositivo

Enviar a mi Kindle o a otro dispositivo

The Data WarehouseETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data de [Kimball, Ralph, Caserta, Joe]
Anuncio de app de Kindle

The Data WarehouseETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data 1 , Versión Kindle

4.0 de un máximo de 5 estrellas 1 opinión de cliente

Ver los 3 formatos y ediciones Ocultar otros formatos y ediciones
Precio Amazon
Nuevo desde Usado desde
Versión Kindle
"Vuelva a intentarlo"
EUR 30,49

Kindle Unlimited
Lee más de 1 millón de eBooks en cualquier dispositivo Kindle o en la aplicación gratuita Kindle. Pruébalo gratis durante 30 días

Descripción del producto

Descripción del producto

  • 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


The single most authoritative guide on the most difficult phase of building a data warehouse

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. Along the way you'll learn how to:

  • Plan and design your ETL system
  • Choose the appropriate architecture from the many possible options
  • Build the development/test/production suite of ETL processes
  • Build a comprehensive data cleaning subsystem
  • Tune the overall ETL process for optimum performance

Detalles del producto

  • Formato: Versión Kindle
  • Tamaño del archivo: 5228 KB
  • Longitud de impresión: 528
  • Editor: Wiley; Edición: 1 (10 de diciembre de 2007)
  • Vendido por: Amazon Media EU S.à r.l.
  • Idioma: Inglés
  • ASIN: B006JAWFE4
  • Texto a voz: Activado
  • X-Ray:
  • Word Wise: No activado
  • Lector con pantalla: Compatibles
  • Tipografía mejorada: Activado
  • Valoración media de los clientes: 4.0 de un máximo de 5 estrellas 1 opinión de cliente
  • Clasificación en los más vendidos de Amazon: n.° 337.264 de Pago en Tienda Kindle (Ver el Top 100 de pago en Tienda Kindle)
  • ¿Quieres informarnos sobre un precio más bajo?

Opiniones de clientes

4.0 de un máximo de 5 estrellas
5 estrellas
4 estrellas
3 estrellas
2 estrellas
1 estrella
Ver opinión de cliente
Comparte tu opinión con otros clientes

Principales opiniones de clientes

Formato: Tapa blanda Compra verificada
In perfect state. Only downside was delivery time. Everything else was perfect.

For me, This book is essential in my bibliography
Comentario ¿Esta opinión te ha parecido útil? No Enviando comentario...
Gracias por tu opinión.
Lo sentimos, no hemos podido registrar tu voto. Vuelva a intentarlo
Informar de un abuso

Opiniones de clientes más útiles en (beta) (Puede incluir opiniones del Programa de Recompensas de Opiniones Iniciales) 4.4 de un máximo de 5 estrellas 36 opiniones
4 de 4 personas piensan que la opinión es útil
3.0 de un máximo de 5 estrellas A lot of talk with no action 17 de enero de 2014
Por Arthur Bekker - Publicado en
Formato: Tapa blanda Compra verificada
This is a good book to read if you want to put yourself to sleep. The writing is rather dry and important concepts are not clearly and easily explained. There's a reason why they say to reread one of the chapters, it is just not easily comprehensible. By providing more data examples, this book would go a long way in explaining some of the more difficult to comprehend concepts. Also, since some of the words are defined and reused throughout the book, it would have been great if the definitions would be better.

Given that this book was written more than 10 years ago, many things have changed and an update is desparately needed.
3 de 3 personas piensan que la opinión es útil
4.0 de un máximo de 5 estrellas Top Reference Manual for ETLers 10 de julio de 2013
Por Michael G. Bradford - Publicado en
Formato: Tapa blanda Compra verificada
There's a lot of info here and it amounts to a college text. It's very in depth and will require as much time as any college text would. Several chapters stand out like Cleaning and Conforming. Metrics development is discussed in depth in ways that may have been overlooked in other texts like this one. The examples go very deep into generation of surrogate keys, bulk loading of Type 1s, minimum key requirements in dimensions and other ETL concepts concerning the error audit table. The book was written very obviously from practical situations encountered in daily work.

The book does not present or attempt to develop the "Kimball Method" of SCD. As it turns out, that's far less important than all the other things required simply to do a day's ETL cycle for which much may go wrong. Numerous tips are worked into this text. It seems that the small things add up greatly throughout a review of the book. For example, it's a mistake to allow NULLs ever to be the prime indicator for an active Type 2 record specifically because a simple SQL call needing a date range controlled by BETWEEN will fail if the active indicator is NULL. It's the fine points like this that rate this book very highly.

This is not a trivial one-time-only to read book. It seems that this sort of preparation should be more in evidence in many of the shops. Let's face it. IT but especially ETL is a high end engineering discipline, more so with EDW.

As far as criticisms are concerned, the SQL examples are good but are PL/SQL and require time to decode for those developing in MSSQL environments. The book was written in 2002 when Oracle was the main player and there were not so many Teradata shops. That may make the book too back level for some readers. However, the book covers most of the subject matter devoid of specific implementation specifics, enough so that the key concepts would work regardless of the technology chosen.

It's not very likely that a course like this one would even be taught at a college level and for that reason the book is a key investment. Further, this book could be used for two full semesters, based on this reviewer's experience in formal course work. It's not likely that on-the-job training would supplant the need for the knowledge contained in this book or one like it.
2 de 2 personas piensan que la opinión es útil
5.0 de un máximo de 5 estrellas A field manual for the professional 12 de mayo de 2007
Por Rufus T. Fuddpucker, Esq. III - Publicado en
Formato: Tapa blanda Compra verificada
I've been doing this for 9 years, and this is the best book I've seen on ETL procesing and its role in data warehousing. Before you start your data warehouse effort have your team read this book. Not just the ETL members...both the front/back room technicians will benefit from understanding the clear presentation of what can be in scope (dare I say, "best practice" yikes!) for ETL processing. The ideas for capturing highly valuable data quality and cleansing processes is no less helpful than the emphasis on loading the data unless it is misleading enmasse or so obviously flawed. The bias toward driving the data to the front room for presentation forces data quality issues to the surface where they must be dealt with and the loop to operational systems (or perhaps even flawed ETL transforms!) closed. Illustrates alternatives for dealing with the messy reality of suspended data, late arriving facts and dimensions. Use it as a guide for your ETL efforts. Buy this book, read it and then buy a few more for your team if you agree.
1 de 1 personas piensan que la opinión es útil
3.0 de un máximo de 5 estrellas Cannot view the diagrams on kindle 28 de diciembre de 2013
Por M. Miller - Publicado en
Formato: Versión Kindle Compra verificada
This seems to be a good book but I would not suggest getting the kindle version as I am not able to view the diagrams on my kindle they are way too small and cannot be resized. You miss key information from not being able to view the diagrams. Apart from this I would recommend the book, just not the kindle version. I have the Black and white Kindle, not the new Kindle Fire. Not sure if that makes a difference.
9 de 12 personas piensan que la opinión es útil
5.0 de un máximo de 5 estrellas Indispensable How-To for all ETL Architects/Developers/Mgrs 4 de enero de 2005
Por Doug Little - Publicado en
Formato: Tapa blanda Compra verificada
Ralph Kimball has rounded out his complete recipe for building fast, cost effective, robust and durable enterprise dimensional data warehouses with this immensely valuable addition to all IT & Data Warehouse professionals' bookshelves.

Without a doubt ETL has been the biggest stumbling block to deploying and maintaining well architected data warehouses that stand the test of time. Ralph draws on his years of experience and engagement with thousands of projects and crystallizes the `Best Practices' into an effective application architecture for all ETL systems regardless of what tools projects use for implementation.

In this thorough examination of the Extract, Transform and Load (ETL) process, Ralph identifies 38 critical functions that all ETL systems need to implement for success in the long haul. He thoughtfully lays out simple and practical approaches for how each of these functions can be implemented by projects with any size of budget.

For many, the paradoxical nature of ETL (seeming trivial yet replete with endlessly complex details that constantly change) has been the proverbial straw that has broken the bank for many DW projects. Continual customer pressure to grow, improve performance, and quickly deal with changing business conditions have left developers and architects grasping for more powerful and flexible approaches to ETL that meet project timelines, yet evolve and improve with age. Armed with this enlightening roadmap, many DW professionals will be far better equipped to design and build systems that meet the challenges today and tomorrow.
click to open popover