This option enables you to add related tables in the diagram; tables that are related through the source mappings or through relations in the source system.
Below is an example of a fact table in a Star Schema Model diagram.
- Right-click on the header part of the table fact_orders and choose Table, then Add related tables.
- From the Add related entities, select the tables to add.
- For each table selected, you will be prompted to choose a table type and to change the table name if necessary.
- The Customer table will now be displayed in the diagram as a changing dimension. The foreign key join is also displayed, showing how the dim_customer table is related to the fact_orders table.