Elaborating a bit more. Business stakeholders are seldom interested in history records, especially when it comes to labels/names. Sounds like you don't have a detail data store - which is the natural place to keep a complete history record. Then you can more easily design and create data marts (dimensions and facts) that business requires at the moment. This will hopefully lead to smaller and more easy to use data patterns (and not so much historization, and fewer columns).   Btw, by not track changes as Type 2, it does not necessary mean classifying them as type 1, it just means that they are only updated when any type 2 columns for the row has new value. ... View more