Page History
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.
REPLACE WITH THIS IMAGE: Images/Entities/Adding Related Tables.png
- Right-click on the header part of the table fact_orders and choose Table, then Add related tables.
...
- From the 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 the dim_customer table is related to the fact_orders table.
...