This option enables you to set the DSS Columns.
Columns
Set the DSS Columns.
Fields | Description |
---|---|
dss_create_time | Column added to all Stage, ODS, EDW 3NF, Dimension, Fact and Aggregate tables for information purposes only. Leave the field blank to deactivate or add a name for the dss_create_time column, default is dss_create_time. |
dss_update_time | Column added to all dimension, stage and fact tables. It is required if the generated code for fact and aggregate tables is to be used. |
dss_start_date | Column used for slowly changing dimensions. It is used to identify when a dimension row was replaced. This is a required field. |
dss_end_date | Column used for slowly changing dimensions. It is used to identify when a dimension row was replaced. This is a required field. |
dss_version | Column used for slowly changing dimensions. Is it used to store the version of a dimension row. This is required for unique constraints. |
dss_current_flag | Column used for slowly changing dimensions. It is used to identify the current dimension row. This is a required field. |
dss_count | Column added to fact tables to provide a simple row counter. This is required but can be deleted after generation. Leave the field blank to deactivate. |
dss_change_hash | Column used to identify the differences in the descriptive columns of a Satellite table which is used for generating the change hash key for a Satellite object. Refer to Creating Data Vault Stage Tables for details. |
dss_load_date | Column used to store the date when the value in this row was loaded into the metadata repository. This column and the dss_record_source column below is added to new Load tables that have the option Add meta data columns to table selected. Refer to Data Vaults for details. |
dss_record_source | Column used to store a descriptive term to identify the source of this record. This column and the dss_load_date column above is added to new load tables that have the option Add meta data columns to table selected. Refer to Data Vaults for details. |