1 Load a copy of the QAD metadata repository into an otherwise empty test environment. See the Installation and Administration Guide for instructions on how to load a metadata repository.

2 Ensure there are no public synonyms that point to existing table names, if the rebuild process is to use the same names as some or all of the existing tables.

3 Create connections to the new test data warehouse and to all the source systems.

4 Using the source system knowledge from the existing data warehouse, create the appropriate load tables in the data warehouse based on the existing extract or load methodology.

5 Build up the dimension, stage and fact tables using the same column and table names where possible.

6 Examine the existing procedures or update methodology and include this into the generated stored procedures.

7 Test the new environment.

8 Work out a plan to convert the existing data into the new data warehouse. Where possible it is best to keep existing key values and re-assign sequences to match these existing key values where appropriate.

9 Convert and test the old data warehouse data in the new environment.

10 Redeploy the end user tool access.