Staging > Manual Dimension Join
  
Manual Dimension Join
This checkbox can be set to change the way the dimension table is looked up during the staging table update procedure build. Enabling this option allows you to join to the dimension manually in the Cursor mapping dialog (where the Where clause is built). The usual dialog for matching the dimension business key to a column or columns in the staging table is not displayed if this option is enabled.