Siebel Data Warehouse Installation and Administration Guide > Administering and Troubleshooting the Siebel Data Warehouse >

Populating the Initial Siebel Data Warehouse

The Siebel Data Warehouse Server populates the Siebel Data Warehouse using prebuilt ETL (Extract, Transform, Load) processes residing in the Siebel _DW Rep. The source database is the Siebel transactional database (OLTP). To populate the Siebel Data Warehouse, you can do a full load or a refresh load.

A full load completely populates the Siebel Data Warehouse. You normally do a full load once upon installing Siebel Data Warehouse, and after subsequent customizations of the star schemas (read Performing the ETL Process).

Typically you do a refresh load on a regular basis, such as once a week or once a month, depending upon your business needs (read To do a refresh load).

Siebel Data Warehouse has workflow processes predefined in the Workflow Manager.


 Siebel Data Warehouse Installation and Administration Guide
 Published: 09 September 2004