Modeling Dimensions with History Tracked, Generic Attributes 2012-07-06 Data Modeling No Comments Data Warehouse, Dimensional Models, Historizing, Predictability, Query Plans
Why “Date BETWEEN FromDate AND ToDate” is a dangerous join criteria 2012-06-29 Data Modeling No Comments Data Warehouse, Dimensional Models, Histogram, Historizing, OLTP, Query Plans, Statistics
Why Surrogate Keys are not Good Keys 2011-10-22 Data Modeling No Comments Data Warehouse, Dimensional Models, ETL, Historizing, Keys, Relational
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