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.

  1. Right-click on the header part of the table fact_orders and choose Table, then Add related tables.
  2. From the Add related entities, select the tables to add.
  3. For each table selected, you will be prompted to choose a table type and to change the table name if necessary.
  4. 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.
  • No labels