Join properties view

The Join properties view shows the details of a join between two tables. You can open the view by double-clicking a join on the canvas.

The Join properties view contains the following tabs:

General

On the General tab of the Join properties view, you can specify a name and a description for the join.

Name: The name of a join must be unique.
Description: Optionally, you can add more information about the join.

Join Details

On the Join Details tab of the Join properties view, you can view information about the joined tables, the join type, and the join conditions.

The following join types are available:

Inner

For each pair of matching rows, one row is contained in the join result.

This row contains values from both tables in the result columns. Use Inner join most of the time.

Left outer

For each pair of matching rows, one row is contained in the join result.

This row contains values from both tables in the result columns. In addition, each unmatched row from the left table is contained in the result. For these unmatched rows, all values in columns of the right table are null.

Use Left Outer join to make sure that all the rows from one table are contained in the result. This might be required, for example, when a (left) transactional table is joined with a (right) dimension table and the (right) dimension table might not contain all the values.

Right outer

For each pair of matching rows, one row is contained in the join result.

This row contains values from both tables in the result columns. In addition, each unmatched row from the right table is contained in the result. For these unmatched rows, all values in columns of the left table are null.

Use Right Outer join to make sure that all the rows from one table are contained in the result. This might be required, for example, when a (left) transactional table is joined with a (right) dimension table, and you want to ensure that all dimension values are present in the result.

Full outer

For each pair of matching rows, one row is contained in the join result.

This row contains values from both tables in the result columns. In addition, each unmatched row from the left table and each unmatched row from the right table is contained in the result. For these unmatched rows, all values in columns of the other table are null.

Use Full Outer join to make sure that all the rows from both tables are contained in the result.

A pair of rows from the two selected tables is matching, if all the join conditions are satisfied.

You can create a new join condition by selecting Create a New Join Condition in the toolbar.

To edit an existing join condition, select it in the table and click Edit the Selected Join Condition in the toolbar.

You can delete selected join conditions or all join conditions by clicking Delete the Selected Join Conditions or Delete All Join Conditions.

Feedback