DW_EFFECTIVE_START_DATE

Business Definition

DW_EFFECTIVE_START_DATE represents the date and time when a record in the WELD_NORTH_PROD.WNE_DIM_MODEL.USER_ORG_DIM table becomes active and valid. It is used to track changes over time in a slowly changing dimension, allowing users and analysts to understand the historical context of data and perform accurate time-based analysis.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2025-12-10T02:27:05.811000 by MARKDOWN_IMPORT