Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Enterprise Contact Center Analytics >

Loading the Fact Table

This task is explained by taking the example of the IA_REP_ACTVTS fact table.

Loading the IA_REP_ACTVTS fact table requires the following ETL processes:

1. The M_F_REP_ACTVTS_EXTRACT mapping extracts the data from file_rep_actvts.csv and populates the TF_REP_ACTVTS staging table.
2. The M_F_REP_ACTVTS_LOAD mapping sources the data from the staging table, and the fact ADI mapplet resolves the dimension key by doing a lookup on IA_EVENT_TYPES using the values supplied in the ACTIVITY_TYPE_ID column and the SOURCE_ID column. Then, the ADI populates the IA_REP_ACTVTS fact table.

Since the dimension *_ID values are supplied through the Universal Interface flat file, it is critical that you supply the same value for the KEY_ID in the dimension table and the corresponding *_ID field in the joined fact table. In addition, you must verify that the SOURCE_ID column values match (for Universal Sources, the value of the SOURCE_ID column is GENERIC). If you supply different values for the two tables, the fact table load mapping is not able to resolve the dimension key. As a result, you cannot perform queries on the fact table using that dimension.