Once the stage table has been defined in the metadata we need to physically create the table in the database. This is achieved by using the right mouse button when positioned over the stage table name and selecting Create (ReCreate) from the popup menu.

A results box will appear to show the results of the creation. The following example shows a successful creation.

The contents of this dialog are a message to the effect that the table was created followed by a copy of the actual database create statement, and if defined the results of any index creates. For the initial create no indexes will be defined.

If the table was not created then ascertain and fix the problem. A common problem is 'Duplicate column' where a column has been accidentally added twice. The best way of finding such a column is to double click on the list heading 'Col name'. This will sort the column names into alphabetic order. Another double click on the heading will sort the columns back into their create order. Column ordering can be changed by altering the column order value against a column's properties.

The next section covers Generating the Staging Update Procedure (on page 330).

Once a stage table has been defined in the metadata and created in the database an update procedure can be generated to handle the joining of any tables and the lookup of the dimension table artificial keys.