Browsing All posts tagged under »SCD Type 2«

Process Modeling – Is this a fact or a dimension?

November 23, 2011

8

This is a question I see a lot on forums (and also get asked) and it’s generally based on confusion around events and processes (such as an incident, a bank application process etc). Let’s remember what the difference is between a fact and a dimension. A fact table stores a business process.  A fact is therefore an […]