|
Siebel Data Warehouse Installation and Administration Guide > Customizing the Siebel Data Warehouse >
Siebel Data Warehouse Customization Scenarios
In customizing the Siebel Data Warehouse, various scenarios are available to you based on whether the data source is the Siebel transactional database (OLTP) or data from a non-Siebel source. The matrix in Figure 17 shows categories of customization scenarios. The kinds of customizations available for each category are described in Table 49. For instructions on how to perform the customizations, see Customization Steps for Siebel Data and Siebel Data Warehouse Customization Steps for Non-Siebel Data." For detailed information about ETL processes and tables, see Siebel Data Warehouse Data Model Reference.
Figure 17. Data Warehouse Customization Scenarios
|
Table 49. Types of Data Warehouse Customization Scenarios
|
|
Type 1 |
Add a column to the data warehouse from a primary source table in the Siebel transactional database (OLTP). |
Using Siebel transactional database data, add a column to the data warehouse from a related source table in the transactional database. |
Using Siebel transactional database data, modify an existing column in the data warehouse. |
Type 2 |
Using Siebel transactional database data, add a new dimension table and use it with an existing fact table. |
Using Siebel transactional database data, add a new fact table. |
Using Siebel transactional database data, add a new dimension table for a new fact table. |
Type 3 |
Using non-Siebel data, add new data as a whole row into an existing dimension table. |
Using non-Siebel data, add a column for an existing dimension table. |
Using non-Siebel data, add a column for an existing fact table. |
Type 4 |
Using non-Siebel data, add a new dimension table. |
Using non-Siebel data, add a new dimension table and use it with an existing fact table. |
Using non-Siebel data, add a new fact table. |
|
