Siebel Analytics Applications Installation and Administration Guide > Customizing the Siebel Data Warehouse > Siebel Data Warehouse Customization Steps for Non-Siebel Data >

Building Custom Fact Tables from External Sources in Siebel Data Warehouse

• New DDLs: New staging and new fact tables
• New Mappings: SDE and SIL mappings
• Case: Loading data for new fact tables
• Reference: SDE and SIL_AssetFact from Siebel_DW_Rep Folder

To build custom fact tables from external sources

1. Follow the steps in Building a Custom Dimension Table from External Sources in Siebel Data Warehouse.
2. In the custom fact SDE process, make sure that fact columns that need to reference standard Siebel dimensions contain ROW_IDS from the Siebel data source.
3. Make sure that the dimension IDs in fact staging table are the same as the INTEGRATION_ID in the corresponding dimension tables. This may require some preprocessing.
4. While creating a custom fact SIL process, make sure the SQL override statement joins with dimension tables. Use DATASRC_NUM_ID as 1 for the dimensions that have data from Siebel and join based on INTEGRATION_ID.
5. For the dimensions that use data entirely from external sources, use the appropriate DATASRC_NUM_ID and the corresponding INTEGRATION_ID. Use the appropriate update strategy to add new or change rows.
6. In the DAC, register the tasks. Make the SIL task depend on its corresponding SDE workflow and all the SIL tasks of its dimensions.