You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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

  1. Right-click on the header part of the table fact_orders and choose Table, then Add related tables.

REPLACE WITH THIS IMAGE: Images/Entities/Adding Related Tablesv_1.png

  1. From the Add related entities, select the tables to add.

REPLACE WITH THIS IMAGE: Images/Entities/Adding Related Tables_2.png

  1. For each table selected, you will be prompted to choose a table type and to change the table name if necessary.

REPLACE WITH THIS IMAGE: Images/Entities/Adding Related Tables_3.png

  1. 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.

REPLACE WITH THIS IMAGE: Images/Entities/Adding Related Tables_4.png

  • No labels