The data warehouse ETL toolkit
by Ralph Kimball, Joe Caserta, Margy Ross, Bob Becker, Joy Mundy, Warren Thornthwaite · first published 2004
50% recommend50% neutral
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
Affiliate links. As an Amazon Associate I earn from qualifying purchases.
Spark, etc, are great, but honestly if you're just getting started I would forget all about existing tooling that is geared towards people working at 300 person companies and I would read The Data Warehouse ETL Toolkit by Kimball: https://www.amazon.com/gp/product/1118530802/ I learned from the second edition, but I've heard even better things about the third. As you're working through it, create a project with real…
on “Ask HN: Simple, beginner friendly ETL / Data Engineering project ideas?” ↗…modeled as a fact table row. If a fact table row exists, it is a measurement. "What is a measurement? A common definition is an amount determined by observation with an instrument or scale." -- The Data Warehouse ETL Toolkit (2004) Wiley Publishing. Maybe facts need their own "directed graph" of publicly accessible acknowledgements. That makes it more complex, since we can't write one value to a cell, but record a series…
on “What Was the Fact?” ↗