---
title: "Parameter Combinations"
canonical: "https://docs.vaultspeed.com/space/VPD/3013246986/Parameter%20Combinations"
format: markdown
---
With all the different parameters available on VaultSpeed, not all combinations of parameters are valid.  Sometimes you will need to set 1 parameter before other parameters become available, or when you set a certain parameter, it will invalidate others.

When parameter combinations are not valid, VaultSpeed will display an error message, and these parameters will be shown in red.  At the front of the parameter, there is a warning sign that, when you hover over it, will indicate why this parameter is invalid.

## General parameter combinations

- OBJECT_NAMES_CASE_SENSITIVE cannot be changed once sources have been defined.
- Prefixes and suffixes of objects and attributes can not both be empty.
- The names of metadata attributes have to be unique.
- The prefixes and suffixes of attributes have to be unique except for hash key attributes, these can have the same names since they appear in different tables.
- The names of objects have to be unique.
- The prefixes and suffixes of objects have to be unique.
- The schema names for EXT, STG, FL, and BV have to be unique.
- The schema names for the DTV and DFV have to be different from EXT, STG, FL, and BV.
- The schema names for DTV, DFV, EXT, STG, CDC, and INI have to be unique for every source in a project since multiple sources can have tables with the same names.
- Once there is a Data Vault with a production date, the schema, object, and attribute names cannot be changed anymore.
- Parameter CDC_RELIABLE can only be enabled for sources with CDC type of 'Incremental load using Modification Flag & Date".


the following parameter combinations are not valid (green means that the parameter is on "Y", red means "N").

| parameter 1 | parameter 2 |
| --- | --- |
| ORACLE_12_2_OR_HIGHER | ORACLE_12_1_OR_HIGHER |
| TIME_ZONE_LOCAL | CDC_TIMESTAMP_WITH_TZ |
| TIME_ZONE_LOCAL | LOAD_TIMESTAMP_WITH_TZ |
| INTRA_LOADCYCLE_CHANGES | SINGLE_LOADCYCLE_TIMESTAMP |
| INTRA_LOADCYCLE_CHANGES | SINGLE_LOADCYCLE_TIMESTAMP |
| CDC_RELIABLE | USE_CDC_TS_AS_LOAD_DATES |


## Dependent parameter combinations

The following table lists the parameters that will be disabled if the first parameter is set to a certain value.

| Parameter | value | disabled parameters |
| --- | --- | --- |
| CDC_RELIABLE | N | USE_CDC_TS_AS_LOAD_DATES |
| DATA_QUALITY_BAD | N | DATA_QUALITY_BAD_COLUMN_PREFIX<br>DATA_QUALITY_BAD_COLUMN_SUFFIX |
| INTRA_LOADCYCLE_CHANGES | N | SINGLE_LOADCYCLE_TIMESTAMP |
| SINGLE_LOADCYCLE_TIMESTAMP | N | INTRA_LOADCYCLE_CHANGES |
| ORACLE_12_1_OR_HIGHER | N | ORACLE_12_2_OR_HIGHER |
| TIME_ZONE_LOCAL | Y | LOAD_TIMESTAMP_WITH_TZ<br>CDC_TIMESTAMP_WITH_TZ |
| DATABASE_TYPE | POSTGRESQL | GENERAL_TIME_FORMAT_ID<br>GENERAL_TIMESTAMP_FORMAT_ID<br>GENERAL_NUMBER_FORMAT_ID<br>GENERAL_DATE_FORMAT_ID<br>USE_MERGE_STATEMENT |
| DATABASE_TYPE | ORACLE | GENERAL_TIME_FORMAT_ID<br>GENERAL_TIMESTAMP_FORMAT_ID<br>EMPTYSTRING_IS_NULL<br>GENERAL_NUMBER_FORMAT_ID<br>GENERAL_DATE_FORMAT_ID |
| DATABASE_TYPE | SQLSERVER | GENERAL_TIME_FORMAT<br>GENERAL_DATE_FORMAT<br>EMPTYSTRING_IS_NULL<br>GENERAL_TIMESTAMP_FORMAT<br>GENERAL_NUMBER_FORMAT |
| DATABASE_TYPE | GREENPLUM | GENERAL_TIME_FORMAT_ID<br>GENERAL_TIMESTAMP_FORMAT_ID<br>GENERAL_NUMBER_FORMAT_ID<br>GENERAL_DATE_FORMAT_ID |
| DATABASE_TYPE | APACHE SPARK | GENERAL_TIME_FORMAT_ID<br>GENERAL_TIMESTAMP_FORMAT_ID<br>EMPTYSTRING_IS_NULL<br>GENERAL_NUMBER_FORMAT_ID<br>GENERAL_DATE_FORMAT_ID |