The option to add default metadata columns to a new Load table object in WhereScape RED.

If the option Add meta data columns to table is selected, two DSS columns (dss_record_source and dss_load_date) are included in the metadata for the table and are populated by transformations. Note that these two DSS columns could equally be applied to other Load tables not used in a Data Vault model but are particularly important to comply with the Data Vault standards.

Custom aliases for the dss_load_date and dss_record_source columns can be defined in the Home> Options > DSS Tables and Columns > DSS Columns to Include and Naming window. If custom DSS aliases are defined then the aliases are used for the column names that are added to the new load tables. Refer to DSS Columns for details.



  • No labels