Description of the illustration sm_design_alias_physical

This diagram illustrates shows an implementation of the Employee table with and without alias.

Table Dim_W_MARKET_D links to the Employee table with the alias Dim_W_EMPLOYEE_D_Market Manager.
Table W_PRODUCT_D links to the Employee table with the alias Dim_W_EMPLOYEE_D_Product_Manager.
Table Dim_W_MARKET_D and W_PRODUCT_D both link to the Employee table without an alias W_EMPLOYEE_D. The link is shown as a dotted line. The dotted line indicates that this implementation causes issues, that is, a conflict between the two joins.

Description of the illustration sm_design_alias_physical_joins.png