In data source tables, set up primary and foreign keys to join the following tables:
Tables that form the fact table. See Selecting Tables for the Fact Table.
Tables within each dimension branch. See Selecting Tables for Dimensions.
When you join tables in the RDBMS, Integration Server detects joins while building OLAP models.