To create data warehouse tables for Oracle ATG Web Commerce Search, load the following SQL scripts into the data warehouse database.
<ATG10dir>/ARF/DW/Search/sql/db_components/
db_name
:
search_datawarehouse_ddl.sql
search_datawarehouse_init.sql
If you are using Search with Commerce, after you create the Search tables, run the following script:
<ATG10dir>/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.