Wizard step - Create Multiple Relations Driving or Not Driving
Applies to
Platform: Microsoft SQL Server · Snowflake · Snowflake dbt · Databricks · Databricks dbt · Fabric Lakehouse · Fabric Warehouse · Oracle
Architecture: Data Vault
Create Multiple Relations Driving and Not Driving are two steps of the Create Driving Key Link and Create Business Driving Key Link wizards. In them, you select the Hubs whose relationships drive the link and those that do not. Earlier versions of this article called the steps Create Relations Driving and Create Relations Not Driving.
Create Multiple Relations Driving or Not Driving
Both wizards have the steps Create Model Object, Create Dataflow, Create Multiple Relations Driving, Define Roles, Create Multiple Relations Not Driving, Define Roles, Map Foreign Key Terms and Add to View.
Each relation step lists the model objects that the link can reference, with a search box:
- Create Multiple Relations Driving, "Select Hub(s) Driving the Relationship": the relationships it creates have Driving Key
true. - Create Multiple Relations Not Driving, "Select Hub(s) not Driving the Relationship": the relationships it creates have Driving Key
false.
- In Create Multiple Relations Driving, tick the Hubs that drive the relationship and choose CREATE RELATIONSHIPS.
- In the following Define Roles step, check the role names and choose DEFINE ROLES.
- In Create Multiple Relations Not Driving, tick the other Hubs and choose CREATE RELATIONSHIPS.
- Check their role names in the second Define Roles step.
To change Driving Key after the wizard, see Edit a Relationship.
Related articles
- Previous: Create a Model Object with the wizard
- Next: Wizard step - Define Roles
- Reference: Driving Key (Relationship)
- See also: Driving Key Link, Business Driving Key Link, Edit a Relationship