Siebel Data Warehouse Installation and Administration Guide > Overview of Siebel Data Warehouse >

Siebel Data Warehouse Requirements


The Siebel Data Warehouse is a database that contains the star schemas created by Informatica. Although it is technically possible to put the Siebel Data Warehouse in the same database as the Siebel Transaction Database, it is not recommended for performance reasons. The Siebel Transaction Database is structured as an Online Transaction Processing (OLTP) database, whereas the Siebel Data Warehouse is structured as an Online Analytical Processing (OLAP) database. Each is optimized for its own purpose. The reasons for not combining the two databases are:

The Siebel Data Warehouse works with native database management systems (DBMS). In addition to the general requirements, there are additional DBMS-specific requirements depending on the DBMS you are using.


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