SCD Type Flashcards by Bethany Marshall

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

Q

Overwrite the changes

A

Type 1

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

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

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

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

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

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