If you did not create the data warehouse tables in your production schema, you must also create data loader local tables. These tables are used by the data loader server, and represent the minimal set of tables required by the ATG platform. These tables should be part of your data warehouse loaders local schema.
Note: All data warehouse loaders are designed to run on a single server. This includes the Search Admin, Self Service and Knowledge data warehouse loaders. If you are running Commerce or other ATG applications, the data warehouse loaders for those applications can also run on the same data warehouse loader server. It is recommended that all of the data warehouse loaders run on a separate application server.
To create data loader local tables, run the following script:
<ATG9dir>/DAS/sql/install/db_name/das_ddl.sql