Enum ScdType
C#
public enum ScdType
Fields
Audit | Specifies that the column should not participate in slowly changing dimension analysis and is used for tracking audit information. |
Error | Specifies that changes to the parent column should produce an error. |
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. |
SurrogateKey | Specifies that the parent column is a surrogate key for the table, uniquely identifying each row but not derived from application data. |
Update | Specifies that changes to the parent column should directly update and overwrite the column value. |