| Bookshelf Home | Contents | Index | Search | PDF | |
Siebel Data Warehouse Installation and Administration Guide > Overview of Siebel Data Warehouse >
Data Flow into the Data Warehouse
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 (OLTP) database, which impacts overall system performance.
For this reason, the Siebel Data Warehouse is an online analytical processing (OLAP) database, which allows you to selectively extract, analyze, and view data. To facilitate this kind of analysis, analytical data is stored in a relational database that considers each data attribute (such as product, account, and time period) as a separate dimension.
The Siebel Data Warehouse is designed using dimensional modeling techniques to support the analysis requirements of Siebel Analytics. The data warehouse derives its data from Siebel operational applications, and includes a prebuilt Informatica repository plus all the scripts necessary to create tables and relationships within the data warehouse. Several prebuilt mappings within the Informatica repository allow the initial loading and periodic refreshing of the Siebel Data Warehouse.
Figure 1 illustrates the data flow into the Siebel Data Warehouse.
| Bookshelf Home | Contents | Index | Search | PDF | |
Siebel Data Warehouse Installation and Administration Guide Published: 09 September 2004 |
