ScdType Enumeration

The ScdType enumeration provides options for how changes to column values are treated in a slowly changing dimension table.

Enumeration Values

Name	Summary
Error	Specifies that changes to the parent column should produce an error.
Update	Specifies that changes to the parent column should directly update and overwrite the column value.
Historical	Specifies that changes to the parent column should update the column value and store the previous value.
Key	Specifies that changes to the parent column should be used as a key value in determining when other columns are changing.
Other	Specifies that the column should not participate in slowly changing dimension analysis.
Audit	Specifies that the column should not participate in slowly changing dimension analysis and is used for tracking audit information.
SurrogateKey	Specifies that the parent column is a surrogate key for the table, uniquely identifying each row but not derived from application data.