DW_EFFECTIVE_START_DATE

Business Definition

Effective start timestamp for this version of the dimension record under SCD Type 2. Represents when this particular version of the item became active. Used for point-in-time queries and historical reporting.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS