SELECT INTO – Moving Data From A to B 2014-05-01 SQL Server Archive No Comments Data Warehouse, ETL, Staging
The Information Staircase 2012-07-01 Data Modeling No Comments Abstraction, Architecture, BI, Data Warehouse, ETL, Staging
The Big Picture – EDW/DW architecture 2011-08-30 Data Modeling No Comments Architecture, BI, Data Warehouse, ETL, HADOOP, Staging
Physically Placing the Maps in the architecture 2011-08-19 Data Modeling No Comments Architecture, Data Warehouse, ETL, Keys, Maps, Master Data, Staging
Transforming Source Keys to Real Keys – Part 2: Using Maps To Fix Key Problems 2011-08-15 Data Modeling No Comments Data Warehouse, Dimensional Models, ETL, Historizing, Keys, Maps, Master Data, Staging, Type2
Transforming Source Keys to Real Keys – Part 1: Introducing Map tables 2011-08-04 Data Modeling No Comments Data Warehouse, ETL, Keys, Maps, Master Data, Staging
An Overview of Source Key Pathologies 2011-07-30 Data Modeling No Comments Data Warehouse, Dimensional Models, ETL, Keys, Master Data, Staging
Data Warehouse Introduction 2011-04-17 Data Modeling No Comments Architecture, Data Warehouse, ETL, Staging