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

1. Follow the steps in Adding a Column in a Standard Dimension Table in Siebel Data Warehouse.
2. 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.
3. Quite likely the SDE process for this will not depend on anything else.
4. Make the Custom SIL process to depend on its custom SDE process and SIL process of the fact table you are extending.