Tag Archives: SCD

Timespan Fact Table

This blog focuses on a fact table primarily used for storing semi-additive measures such as

Slowly-Changing Parent-Child Dimensions – Part 2: The Implementation

Distributing the slides from my talk last night, it was well received and I think

SQL – Using The MERGE Statement To Apply Type 2 SCD Logic

Introduced in SQL 2008 the merge function is a useful way of inserting, updating and

Slowly-Changing Parent-Child Dimensions – Part 1: The Theory

A common structure in OLTP systems is a parent-child relationship with Object and ObjectParent tables

Introduction to Slowly Changing Dimensions (SCD) Types

When setting about writing a recent blog post, I wanted to link to a clear,