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. If the end-date is null ...

Some confusion may result from the fact that when the first three SCD types were defined, each could be equated to a result for a dimensional attribute. Type 1 had facts associated to dimension values ...