The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data

The data warehouse etl toolkit shows data warehouse developers how to effectively manage the etl (extract, transform, and load) phase of the data warehouse development lifecycle. The authors show developers the best methods for extracting data from scattered sources throughout the enterprise, removing obsolete, redundant, and inaccurate data, transforming the remaining data into correctly formatted data structures, and then physically loading them into the data warehouse. · requirements, realities, and architecture · data flow · implementation and operations · real time streaming etl systems

• The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition
• The Data Warehouse Lifecycle Toolkit, 2nd Edition
• Star Schema The Complete Reference
• Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema
• The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
• The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Business Intelligence Remastered Collection
• Building the Data Warehouse
• The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset
• SQL Cookbook: Query Solutions and Techniques for Database Developers (Cookbooks (O'Reilly))
• Delivering Business Intelligence with Microsoft SQL Server 2016, Fourth Edition