DW_EFFECTIVE_END_DATE

Business Definition

Effective end timestamp for this version of the dimension record under SCD Type 2. A value of '2999-12-31' indicates the current active version; historical versions have actual end dates. Use this with DW_EFFECTIVE_START_DATE for temporal joins.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

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