Note
These settings are only available/displayed if your WhereScape RED license includes support for custom target databases.
This option enables you to set the DSS Columns for custom database targets.
Data types for Custom Database Targets
Enables you to set the data types that are used in the DSS columns added to new table objects.
Note
- The Hash Key Generation Wizard creates new hub and link hash keys in a Data Vault Stage table with the same data type defined for the dss_change_hash column, if the table is in a Custom database target.
- If the table is not in a Custom database target, the data type CHAR(32) is used.
- Changing this data type has no impact on any existing hash key columns.
Fields | Description |
|---|---|
Default values for Custom Database Targets | Enables you to set the default values that are used when generating update procedures for Slowly Changing Dimension tables and Load tables. |
Start Date for Initial Member | Default date function to use for the start date of rows added in a Slowly Changing Dimension table. |
End Date for Current Member | Default date function to use for the end date of current rows in a Slowly Changing Dimension table. |
Start Date for New Member Entry | Default date function to use for the start date of current rows in a Slowly Changing Dimension table. |
End Date for Expiring Member Entry | Default date function to use for the end date of expiring rows in a Slowly Changing Dimension table. Refer to the Change Detection tab section under Generating the Dimension Update Procedure for details. |
Load Date Transformation | Default date function to use for populating the new records inserted in Load tables. |