SCD Type Flashcards

1
Q

Ignore any changes and audit changes

A

Type 0

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Overwrite the changes

A

Type 1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

History will be added as a new row

A

Type 2

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

History will be added as a new column

A

Type 3

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

A new dimension will be added

A

Type 4

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Combination of type 2 & type 3

A

Type 6

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Flag marking current price as active

SCD

A

Type 2

How well did you know this?
1
Not at all
2
3
4
5
Perfectly