The Pre-join Editor helps you to edit pre-joins in the selected data source of the current catalog. It appears when you select Pre-join in the Catalog Manager toolbar, select a data source and then select OK.
First you need to add some tables. Select Add Tables and then select resources such as tables, views, synonyms, queries, imported SQLs, stored procedures, and user defined data sources from the Add Tables/Views/Queries dialog.
You can then make joins between the tables by using mouse drag and drop. Point to one column in the source table, press and hold the mouse button, then move the pointer to the other column in the target table and release the mouse button. A green line with a join icon will be shown, linking the two columns.
If you want to further edit a join, double-click its join icon and the Join Options dialog will be displayed for you to edit it.
After you have made some joins between the tables, you can then use them to define paths. To define paths, select Edit Paths in the editor.
Pops up the Add Tables/Views/Queries dialog to add or remove resources such as tables, views, synonyms, queries, imported SQLs, stored procedures, and user defined data sources.
Saves all the changes.
Opens the Edit Pre-join Paths dialog to define pre-join paths.
Organizes the tables in the panel to be tidy.
Displays the help document about this feature.