DW_EFFECTIVE_START_DATE

Business Definition

Represents the start date and time when a record becomes active or is inserted. This timestamp marks the beginning of the record's validity period and is crucial for tracking changes over time in a slowly changing dimension. It is set to the current timestamp when the record is created or updated.

Data Type

TIMESTAMP_NTZ

Nullable

No

Last Updated

2025-12-10T02:24:28.384000 by MARKDOWN_IMPORT