When building dimensional models it is crucial to decide on how changes in source data will be represented in dimension tables. This phenomena is called slowly changing dimensions.

When it is not necessary to preserve the history, a Type 1 Slowly Changing Dimension can be used. This technique is commonly used in situations when the changed is implemented to correct an error.

This tutorial provides a practical , follow-along, demonstration of how to manage Type 1 Slowly changing dimensions using T-SQL

I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-...