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

Siebel Data Warehouse Architecture

High-level analytical queries, like those commonly used in Siebel Analytics, scan and analyze large volumes of data using complex formulas. This process can take a long time when querying a transactional database, which impacts overall system performance.

For this reason, the Siebel Data Warehouse was constructed using dimensional modeling techniques to allow for fast access to information required for decision making. The Siebel Data Warehouse derives its data from Siebel operational applications, and uses Informatica's data integration technology to extract, transform, and load data from the Siebel transactional database into the Siebel Data Warehouse.

Figure 2 illustrates the Siebel Data Warehouse architecture.

Figure 2.  Siebel Data Warehouse Architecture