Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Siebel Data Warehouse Installation and Administration Guide > Customizing the Siebel Data Warehouse > Siebel Data Warehouse ETL Process Concepts > About Siebel Data Warehouse Extension TablesThe extension tables are provided with the Siebel Data Warehouse exclusively to help customize the data warehouse tables. CAUTION: Do not customize existing mappings or the database schema. If you need to customize the standard mappings, create a new mapping that loads the extension table instead. For every extension table, there is an extension staging table that is populated by the custom SDE process. The custom SIL process sources data from this staging table and populates the final extension table. For information about how to use extension tables, see Customization Steps for Siebel Data and Siebel Data Warehouse Customization Steps for Non-Siebel Data. The extension tables have a 1:1 relationship with their corresponding dimension and fact tables. The data warehouse extension tables are different from the Siebel transactional database extension tables in the following ways:
Using the Extension TablesThe extension tables have a 1:1 mapping between the dimension and fact records to the extension records. To insert a record into a dimension or fact table, choose the appropriate column and write a new mapping that uses the ETL server's incremental logic to load the staging table. When populating data from the staging table to the final dimension or fact tables using the INTEGRATION_ID and the DATASRC_NUM_ID, find the primary key of the dimension table and use that as the primary key of the extension table. Naming New Extension TablesWhen you create a new extension table, use the same naming convention as is used in the Siebel Data Warehouse by adding the prefix WC to the table name, for example, WC_TABLENAME_DS. This will simply future upgrades to the Siebel Data Warehouse. NOTE: If a new table is created, you need to register the table and its indices in the DAC repository. Also, if you modify indices on existing tables, you need to register the indices. NOTE: If you are creating tables on a DB2-UDB database, make sure the Not Logged Initially option is enabled. Creating New Dimension or Fact TablesYou can create new tables using the same logic as is used for extension tables. CAUTION: The data in any customized table will face upgrade issues. If you are creating a new dimension or fact table, use the required system columns that are part of each of the data warehouse tables to maintain consistency and the ability to reference existing table structures. When you create a new table, you need to register the tables and its indices in the DAC repository. Required ColumnsFor main and extension staging tables the following columns are required:
For data from any external data source assign a number greater than 1. For dimension and fact tables, the required columns are the INTEGRATION_ID and DATASRC_NUM_ID columns as well as the following:
The required columns for dimension and fact extension tables are ROW_WID and ETL_PROC_WID. |
![]() |
![]() ![]() |
Siebel Data Warehouse Installation and Administration Guide |