This option enables you to set the Global Naming of Key Columns.
During the drag and drop generation of new dimension and fact tables, WhereScape RED builds an artificial (surrogate) key for the table.
The naming convention for that key can be set through the same menu option as above. As well as potential pre-fix and suffix values, you also need to choose between the inclusion of the full table name, or the short name assigned to each table. In the example screen above ( which is the default), a dimension table key would use the table short name and have a suffix of "_key". Therefore, a load_customer table example would generate a key called dim_customer_key, if it was dragged into a dimension drop target.
The example above displays the defaults for Dimension options, to set these fields on Fact, Data Store and EDW 3NF tables, etc. expand the fields below Dimension to view and set your required options.
Fields | Description |
|---|---|
Dimension have a Surrogate Key auto added | Select this option if a Surrogate key column is to be added automatically to a table. Default for Dimension is selected. Default for Fact, Data Store and EDW 3NF is not selected. |
Dimension Key Prefix | Key prefix that can be added to a new Dimension Key. |
Dimension Key Name Type | Key name type for new Dimension keys. Select between Short name, Full table name and Base name. |
Dimension Key Suffix | Key suffix that can be added to a new Dimension key. |
Note
For Data Vault table objects, hash keys are added automatically by the Data Vault stage table creation wizard and are required when using WhereScape data vault code generation templates. Therefore, the Hash key auto added option for Hub, Satellite and Link tables are enabled by default and cannot be modified. Refer to Data Vault Settings for details.