SCD Examples

Here we will see some use cases of our Slowly Changing Dimension.

In the first example below, suppose the user wants to see the number of passengers carried by BA, but only the ones after the name change occurred.  You can download the Workflow here .

• we select the Fact table and our Slowly Changing dimension and join them on the Surrogate Key

• then we filter to just select the rows for New British Airways

In the next example below, now suppose the user wants to see the number of passengers carried by BA, but both before and after the name change. The workflow below accomplishes this. The differences from the previous example are :

• Here we filter on the Dimension table before joining with the Fact table. And we filter on the Natural Key (UNIQUE_CARRIER = 'BA')

• Then we join with the Fact table using the Surrogate Key. This will retrieve all 'versions' of BA, as you can see in the pie chart.

You can download this workflow from here .

I hope these 2 examples give you an idea of how useful Type 2 Slowly Changing Dimensions are.