Data warehouse tables can be housed in any database in your system. For performance reasons, you may want to dedicate one or more databases for the purpose. Regardless of which database is used, the data warehouse must reside in a separate schema from other ATG data.
For your data warehouse database, run the following SQL scripts in the order shown:
<ATG2007.3dir>/ARF/DW/base/sql/db_components/<db name>
If you are using internal users, run the following:
<ATG2007.3dir>/ARF/DW/InternalUsers/sql/db_components/<db name>
