SCD Type Flashcards
1
Q
Ignore any changes and audit changes
A
Type 0
2
Q
Overwrite the changes
A
Type 1
3
Q
History will be added as a new row
A
Type 2
4
Q
History will be added as a new column
A
Type 3
5
Q
A new dimension will be added
A
Type 4
6
Q
Combination of type 2 & type 3
A
Type 6
7
Q
Flag marking current price as active
SCD
A
Type 2