Constraint Mode
The table reference constraint mode to apply for the Data Mart database. Allowed values are DoNotCreate, CreateAndNoCheck and CreateAndCheck.
Options: DoNotCreate, CreateAndNoCheck, CreateAndCheck
| Option | Behavior |
|---|---|
DoNotCreate (default) | No reference constraints are modeled for Data Mart tables |
CreateAndNoCheck | Reference constraints are modeled but not enforced against existing data |
CreateAndCheck | Reference constraints are modeled and enforced |
A blank or unrecognized value is treated as DoNotCreate.
When to Change This Setting
Keep the default DoNotCreate when load order manages referential completeness and physical constraints would slow the loads. Use the create options when the star schema's dimension-fact relationships should be expressed as constraints, for example to expose them to reporting and modeling tools.
Related Settings
| Setting | Interaction |
|---|---|
| Constraint Mode DV | The equivalent control for Data Vault tables |
| Constraint Mode STG | The equivalent control for Staging tables |
Notes
- This setting is part of the Data Mart settings category.
- The default value for this setting is
DoNotCreate.