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 >
Adding a Column for a Standard Fact Table in Siebel Data Warehouse
Example: Loading shipping order information into the data warehouse.
- New DDLs: Custom or standard extension tables.
- New Mappings: SDE and SIL mappings.
- Case: Bringing data in for fact tables.
- Reference: CustomSDE and SIL_AssetFact in Custom_DW_Folder.
To add a column for a standard fact table
- Follow the steps in Adding a Column in a Standard Dimension Table in Siebel Data Warehouse.
- Use the CustomTemplateSDE_AssetFact, and CustomTemplateSIL_AssetFact as examples.
If the additional columns include foreign keys to dimension tables, consider the following:
- While joining with the dimensions in the SIL process, use the DATASRC_NUM_ID as 1 for the dimensions that have only data from the main Siebel source and join based on INTEGRATION_ID.
- For the dimensions that have only data from external sources use the appropriate DATASRC_NUM_ID and the corresponding INTEGRATION_ID.
- Use the appropriate update strategy to change and insert rows.
- Quite likely the SDE process for this will not depend on anything else.
- Make the Custom SIL process to depend on its custom SDE process and SIL process of the fact table you are extending.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide Published: 11 March 2004 |