Siebel Data Warehouse Installation and Administration Guide > Customizing the Siebel Data Warehouse > Customization Steps for Siebel Data >

Adding a New Dimension Table for a New Fact Table in the Siebel Data Warehouse


  • Adding a new custom dimension WC_NEWDIM_D and linking it to new custom WC_BKLOG_F fact table.

The steps for creating a new dimension table are similar to the steps for incremental change capture.

To add a new dimension table for a new fact table

  1. In the new custom fact loading mapping (SIL), use lookups for getting foreign keys to the new dimension.
  2. Use existing maps as examples.
Siebel Data Warehouse Installation and Administration Guide