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 Transaction 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 Analytics, 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 Analytics has batch processes predefined in the Server Manager.


 Siebel Data Warehouse Installation and Administration Guide, Version 7.5, Rev. C 
 Published: 18 April 2003