Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Data Warehouse Installation and Administration Guide > Customizing the Siebel Data Warehouse > Siebel Data Warehouse Customization Steps for Non-Siebel Data >
Linking the Custom Dimension to a Standard Fact Table in Siebel Data Warehouse
- New DDLs: New fact extension tables or standard fact extension tables
- New Mappings: Fact SDE and SIL mappings
- Case: Loading data for fact tables that reference the new custom dimension tables
- Reference: CustomSDE and SIL_AssetFact in Custom_DW_Folder
To link the custom dimension to a standard fact table
- Extend the fact tables by creating or using fact extension tables.
- A custom SDE mapping has to be designed to populate the additional foreign key column in the extension stage table. Make sure that the dimensions ID in the fact staging is the same as the integration of the custom dimension. This may require some preprocessing.
- A custom SIL process loads data from the staging table to the fact extension table.
- Develop the SQL override for populating the fact extension table to extract foreign keys for the new dimension table. Specifically, write the query to extract the ROW_WID of the custom dimension table using INTEGRATION_ID and DATASRC_NUM_ID of the dimension in combination.
- Ignore the rows for which there is not a matching ROW_WID value.
- In the DAC, register the SDE and SIL tasks. Make the SIL mapping depend on its corresponding SDE mapping and the SIL mapping of the base fact table.
- Add the custom dimension to the fact table group.
Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Data Warehouse Installation and Administration Guide Published: 11 March 2004 |