Removing join relationships

Use the Warehouse Schema Model window to remove join relationships between columns in tables that are displayed on the canvas. Any join relationship can be removed (primary foreign key, or non-keyed columns). When a join relationship removed, only the relationship in the warehouse schema is deleted. The primary foreign key is not deleted.

  Authorities and privileges

To remove join relationships between columns:

1. Open the Warehouse Schema Model window.

2. Multi-select the join lines that you want removed; then right-click and select Remove. The join relationships are removed when you click Save.

Related information

Warehouse Schema Modeler -- Overview