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

Loading the Dimension Table

This task is explained by taking the example of the IA_EVENT_TYPES table.

Loading the IA_EVENT_TYPES table requires the following ETL processes:

1. The M_F_EVENT_TYPES_EXTRACT mapping extracts the data from file_event_types.csv and populates the TF_EVENT_TYPES staging table.
2. The M_F_EVENT_TYPES_LOAD mapping sources data from the staging table and passes it over to the Analytic Data Interchange (ADI). The ADI generates the surrogate key for each record in the staging table, then inserts it into IA_EVENT_TYPES target table.