Bookshelf Home | Contents | Index | Search | PDF

Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring the Siebel Data Warehouse >

Setting Up the Siebel Data Warehouse

---

The Siebel Data Warehouse consists of the following components:

Siebel Data Warehouse repository (Informatica repository)
Star schema tables that hold the Siebel Data Warehouse information (populated by Informatica)

These two components are installed in the same database or in different databases.

Prerequisites to Setting Up the Siebel Data Warehouse

Before you execute the batches with Informatica, you must do the following:

Restore the Informatica repository and create the data warehouse tables.

These tables are empty until populated by the predefined batches as covered in Table 5, Predefined Full Load Batch Processes.

Make sure that a role named SSE_ROLE is created for both Siebel Data Warehouse (OLAP) and Siebel Transaction Database (OLTP).

Bookshelf Home | Contents | Index | Search | PDF