News
There is another implementation option, and as such it should likely be considered yet another SCD Type, but, not believing in SCD-type proliferation, I suggest only that this is yet another variation ...
SCD type 2 will store the entire history in the dimension table. In SCD type 2 effective date, the dimension table will have start-date and end-date as the fields.
Slowly Changing Dimension Type 3 preserves only few history versions of data, most of the time ‘Current’ and Previous’ versions.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results