Creating Search Data Warehouse Tables

To create data warehouse tables for ATG Search, load the following SQL scripts into the data warehouse database.

<ATG9dir>/ARF/DW/Search/sql/db_components/db_name:

If you are using Search with Commerce, after you create the Search tables, run the following script:

<ATG9dir>/DCS/DW/Search/sql/db_components/db_name/dcs_srch_ddl.sql

Note: There are foreign key dependencies among the tables created by dcs_srch_ddl.sql and the Search and platform tables.

 
loading table of contents...