Settings for Data Vault objects can be configured from the Tools > Options screen.

Object Types Settings

The Default Sub Type for Stage Table Objects drop-down includes the Data Vault Stage option. 

Configure this setting, if you want to set Data Vault Stage to be the default Table Type in the Stage Table Properties screen.   

Global Naming Conventions Settings

Global Naming of Tables

The Global Naming of Tables setting for Hub, Satellite, and Link tables has been set to comply with the recommended standard naming convention for Data Vault tables.  You can edit this setting to suit your requirements.

Global Naming of Key Columns

The Global Naming of Key Columns setting for Hub, Satellite, and Link tables enables you to define the default naming convention for the Hash Keys that are generated for these Data Vault objects (e.g. Key Prefix value plus the Source Column name). You can edit this setting to suit your requirements.

WhereScape RED was enhanced to comply with Data Vault 2.0 standards. The Hash keys are now generated as part of the Data Vault Stage table creation wizard which are then passed during the drag-and-drop creation of new Data Vault objects. Hence hash key columns are now mandatory and must not be added during the creation of a Data Vault object.

DSS Tables and Columns Settings

The DSS Columns to Include and Naming setting includes two additional columns which are described below:

  • dss_create_time – this column is added to all Stage, ODS, Normalized, Dimension, Fact and Aggregate tables for information purposes only. Leave blank to deactivate.
  • dss_change_hash – this column is used to identify the differences in the descriptive columns of a Satellite table which is required for generating the change hash key for a Satellite table.

Data Vault

The Data Vault setting is used to define the data type for the generated Hash Keys in RED that are used to build the Hub, Link, and Satellite table objects.
Also, the Satellite Multi-Active Sequence Key option allows you to define how this key is represented in the Data Warehouse. The Sequence Key Data Type is INTEGER, by default.

Changing this data type has no impact on any existing hash key columns.


  • No labels