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

Adding a New Fact Table in the Siebel Data Warehouse

• Creating a new custom WC_PROJECT_F by sourcing data from S_XYZ table.

Reference:

• SDE and SIL_AssetFact.

To add a new fact table

1. Create a DDL for the new fact based on the standard structure (with appropriate system columns). Create a staging table for this fact.
2. Register the new source table (if it does not already exist) in the DAC repository and associate it with a database connection.
3. Assign it an image suffix.
4. Create the change capture tables by right-clicking and selecting Generate Change Capture Scripts. For instructions, see Including a Source Table for Change Capture Process.
5. Create SDE mappings to populate the custom stage table. Use the view created by change capture as the main table in the SQL so that it extracts only the incremental data. Use the reference maps (above) as examples of how to populate the system columns. Be sure to truncate the stage table in corresponding workflows.
6. Create SIL mapping to populate the custom fact table. Use reference maps as examples of how to populate the system columns.
7. Use lookups or SQL override joins to dimension tables for populating dimension foreign keys (ROW_WIDs) pointing to the existing dimension.
8. In the DAC, register the target tables.
9. Because this is a fact table, create a new table group with this fact table as the main table.
10. Associate the fact table to the group with the relationship as Self.
11. Associate all the dimension tables.
12. Add the newly created group to the appropriate subject area.
13. Create new tasks for the workflows.
14. For the SDE task, make sure you have the Build Image flag set to True, and list all the source tables that it queries from. Choose one or more tables as primary or auxiliary. For the target tables choose the staging table. Set the Truncate Always flag to True.
15. For the SIL task, list all the dimensions that will be required under source tables, and make it depend on the SDE task of the custom fact table and SIL tasks of all the dimension tables.