In this video, I will show you how to finalize your initial ETL load for your NorthWind Datawarehouse. Specifically, I will show you how to create the EDW area for your data, how to create a persistent date dimension (that does not get updated from source tables) and generating/setting surrogate keys.
The video also talks about Kimballs recommendations for surrogate keys on the date dimension.
Part 1 is here: https://youtu.be/sTWeKVtdVko
