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.