Bookshelf: 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 OLTP database or data from a non-Siebel source. The matrix in Figure 10 shows categories of customization scenarios. The kinds of customizations available for each category are described in Table 32. 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.

Table 32. Types of Data Warehouse Customization Scenarios
Type	Modification
Type 1	Add a column to the data warehouse from a primary source table in the Siebel OLTP database
	Using Siebel OLTP data, add a column to the data warehouse from a related source table in the Siebel OLTP database
	Using Siebel OLTP data, modify an existing column in the data warehouse

Type 2	Using Siebel OLTP data, add a new dimension table and use it with an existing fact table
	Using Siebel OLTP data, add a new fact table
	Using Siebel OLTP 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
	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