References
Configures generated references and relationship inheritance.
Use this page to find the References settings, review their defaults, and open the detailed parameter pages.
Available parameters
| Parameter | Technical name | Default value | Purpose |
|---|---|---|---|
| Autocreated References Use Friendly Name | AUTOCREATED_REFERENCES_USE_FRIENDLY_NAME | 0 | Use friendly names instead of table names in description of autocreated references: 0 - No, 1 - Yes. |
| Delete Unused References On Delete Columns | DELETE_UNUSED_REFERENCES_ON_DELETE_COLUMNS | 0 | Delete unused references on delete columns: 0 - No, 1 - Yes. |
| DWH Create References | DWH_CREATE_REFERENCES | 0 | Create disabled references between tables in data warehouse. |
| Ref Tables Recursion Depth | REF_TABLES_RECURSION_DEPTH | 5 | Max recursion depth during the detection of referenced tables in the transformation wizard. |
| Reference PK To PK Cardinality | REFERENCE_PK_TO_PK_CARDINALITY | 0 | Cardinality of PK-to-PK reference. 0 - N:1, 1 - 1:1. |
| References Datamart | REFERENCES_DATAMART | 0 | 0 - all references are allowed, 1 - only references between objects in the same star are allowed, 2 - only references between the objects in the same schema are allowed. |
| References Inheritance | REFERENCES_INHERITANCE | 0 | 0 - within schema only, 1 - within layer only, 2 - within layer and its neighbourhood, 3 - everywhere. |
| References Inheritance Force Manually Created | REFERENCES_INHERITANCE_FORCE_MANUALLY_CREATED | 0 | 0 - manually created references will be inherited like all other references, 1 - manually created references will be always inherited, 2 - manually created references and their successors will be always inherited. |
