Data Warehouse Corner

ERwin r8 – Data Movement Sources

In this article we’ll discuss the updated Data Movement features in Erwin R8 that identify data sources, data targets, and transformation logic. You might be wondering why you’d use a data modeling tool to map data movement and refresh rules, … Read more

Normalization – Myths and Facts

In this article we’ll identify how normalization and denormalization differ between OLTP and Data Warehouse models. We’ve all heard about normalization, based on CODDS theory and how it’s supposed to be applied in the design phases of application development. First … Read more

Modelling the Data Warehouse

This issue – we discuss types of models, their characteristics, nature, and application. Welcome to Data Warehouse Corner. Each issue we’ll identify a business problem facing the Data Warehouse / BI data modeller and discuss solutions and implications for the … Read more