Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse on Windows > Configuring the Siebel Data Warehouse Database >

Creating and Dropping Data Warehouse Tables on a Teradata Database

This section includes the procedures for creating and dropping data warehouse tables on a Teradata database.

NOTE:  For Unicode environments, perform these procedures using a login that has the default character set UTF-8.

To create data warehouse tables on a Teradata database

1. Navigate to SiebelAnalytics\dwrep.
2. Copy the script create_dw_tera.sql to SQL Assistant and execute it.

To drop data warehouse tables on a Teradata database

1. Navigate to SiebelAnalytics\dwrep.
2. Copy the script drop_dw_tera.sql to SQL Assistant and execute it.