Loading Facts with Type 2 SCD

As mentioned, when we use Type 2 Slowly Changing Dimensions, we also have to revise the way we load our Facts table.

You can download the workflow here 

For each Type 2 SCD we want to use, instead of loading the Natural Key (e.g., BA) into the Facts table, we will look up the latest (valid) Surrogate Key FROM THE DIMENSION TABLE (e.g., 488) and use this one instead.

As a consequence of this, when we put all things together, it is important to load all our Dimension tables BEFORE loading the Facts table.

Below you can see the new resulting Facts table. Notice the column CARRIER_SKEY at the end. 

On the next page we will see some practical use cases of our Type 2 Slowly Changing Dimension.