If columns from multiple source tables were used to create the dimension then the following dialog will appear at the start of the procedure creation process.

The choice provided is either to create a join that will combine all the information from the various tables into one large select statement, or to do a series of lookups.

The normal process would be to join the tables to create one large select statement. There are however situations where this is not desirable or possible. When a large number of tables are involved then a join will be slower than a series of lookups. In some situations we may not have all the information to do an initial join. A series of lookups may be required to build up the information.

For complex situations it will be necessary to edit and enhance the generated procedure code.

If Lookup is chosen then the primary table for the dimension must be chosen. The philosophy here is that a series of lookups will be conducted against the secondary tables using information from this primary table.