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 >
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
- Follow the steps in Building a Custom Dimension Table from External Sources in Siebel Data Warehouse.
- 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.
- 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.
- 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.
- 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.
- In the DAC, register the tasks. Make the SIL task depend on its corresponding SDE workflow and all the SIL tasks of its dimensions.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide Published: 11 March 2004 |