Table of Contents Cover Title Page Copyright Dedication About the Authors Credits Acknowledgments Introduction The Origins of Kettle About This Book How This Book Is Organized Prerequisites On the Website Further Resources Part I: Getting Started Chapter 1: ETL Primer OLTP versus Data Warehousing What Is ETL? ETL, ELT, and EII Data Integration Challenges ETL Tool Requirements Summary Chapter 2: Kettle Concepts Design Principles The Building Blocks of Kettle Design Parameters and Variables Visual Programming Summary Chapter 3: Installation and Configuration Kettle Software Overview Installation Configuration Summary Chapter 4: An Example ETL Solution—Sakila Sakila Prerequisites and Some Basic Spoon Skills The Sample ETL Solution Summary Part II: ETL Chapter 5: ETL Subsystems Introduction to the 34 Subsystems Summary Chapter 6: Data Extraction Kettle Data Extraction Overview Working with ERP and CRM
