ETLScd class
ETL family — class
ETL SCD (Slowly Changing Dimension) component for managing dimension updates. Displays as a special cylinder with historical tracking icon. Supports Type 1 (overwrite) and Type 2 (historical with effective dates).
Members
| Member | Kind | Description |
|---|---|---|
ScdType Type | Property | SCD Type: Type1 (overwrite), Type2 (historical) |
string BusinessKeys | Property | Business key columns (CSV) for matching existing records |
string ChangeTrackingColumns | Property | Columns to track for changes (CSV) |
string EffectiveFromColumn | Property | Column name for effective from date (Type 2 only) |
string EffectiveToColumn | Property | Column name for effective to date (Type 2 only) |
string CurrentFlagColumn | Property | Column name for current flag (Type 2 only) |
string TableName | Property | Target dimension table name |
ETLScd() | Method | Initializes a new instance of the ETLScd class. |