The Data Modeling Workspace › Logical and Physical Modeling › How to Resolve Many-to-Many Relationships

How to Resolve Many-to-Many Relationships

You can resolve many-to-many relationships in both logical and physical models:

• Right-click a relationship on the diagram window.
• Select the Resolve Many-to-Many Relationship option from the Transformation shortcut menu if you are in the logical model.

Note: In a physical model, the many-to-many relationships are resolved automatically.

More information:

Using a Transformation to Resolve a Many-to-Many Relationship