Load facts with Airports SCD - 2

Below a picture of the final Workflow. You can download it here.

Here is a screenshot of the resulting Facts table :

To see this in action (and check if it all works!) I have created a Report workflow you can see below and copy here 

....and below you can see the result when executing it:

Apparently, everything works fine!

Maybe you think there is an error, because we get an airport in Canada ??? Well no, there IS a town in Canada called London, which has an airport! These kind of 'issues' can only be detected by closely looking at our data.

And in case we only want to see the airports from London, UK all we would have to do is add a condition Country = United Kingdom to the Row Filter node of our Report.

To clean thing up, we can now modify our Facts loading workflow to remove the Origin and Dest columns from the Fact table.