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.
IA_EVENT_TYPES table requires the following ETL processes:
M_F_EVENT_TYPES_EXTRACT mapping extracts the data from file_event_types.csv and populates the
TF_EVENT_TYPES staging table.
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.