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

Creating Data Warehouse Tables

Use this procedure to create the data warehouse tables. Before you perform this procedure make sure the SSE role has been created for the Siebel Data Warehouse and Siebel transactional database and that the database user has been associated with the role.

If you are using a Teradata database, follow the instructions in the section Creating and Dropping Data Warehouse Tables on a Teradata Database.

NOTE:  Additional work by the database administrator is required if the data warehouse tables need to be moved to different tablespaces (for performance or manageability).

To create data warehouse tables

1. From the DAC menu bar, click Tools > ETL Management > Configure.
2. In the Sources dialog box, select the database platform for the target data warehouse, source transactional database, and the Informatica repository.

   The Data Warehouse Configuration Wizard opens.

3. Select the Create Siebel Data Warehouse Tables check box, and click Next.

   The Data Warehouse tab is active.

4. Enter the following information:

   Field	Description
   Database Type	Type of database. If the database type is DB2 390, then check the 390 Database check box.
   Table Owner	Valid database user.
   Password	Valid database user password.
   ODBC Data Source	Data Source Name (DSN) for the Siebel Data Warehouse.
   Data Area	(Optional) Tablespace where data warehouse tables are created.
   Index Area	(Optional) Indexspace where data warehouse indices are created (applicable only to Oracle and DB2 databases).
   Is Unicode	Specifies whether the data warehouse database is Unicode.