To create the data warehouse tables, you load an SQL script into the data warehouse database. The script creates:
The data warehouse tables for the ATG platform, ATG Knowledge, ATG Self Service, and ATG Search.
The data loader tables. These tables are used to queue log files for processing and to track load execution. In the event of a failure, load progress resumes where it left off.
ATG recommends that you create the data warehouse loader tables in your production schema.
To create the data warehouse, load the following SQL script into the data warehouse database:
<ATG9dir>/Service9.3/Service/sql/install/db_name/
service_datawarehouse_all.sql