Slowly Changing Dimensions – Type 3

Slowly Changing Dimensions – Type 3 

• Rarely used
• The previous value (or complete history of previous values) is maintained in the dimension table row.
• This requires modifying the dimension table schema to accommodate new values for each tracked attribute, and can result in a complex dimension table that is difficult to manage. 

References:

https://www.slideshare.net/antoniosch/building-data-warehouse-in-sql-server?from_action=save

And others