Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 Image Added

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

...

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

...

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

...

  1. Image Added
  2. 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.

...

  1. Image Added