Oracle^® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle BI Applications Consumer >

Loading the Dimension Table

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

Loading the W_EVENT_TYPE_D table requires the following ETL processes:

1. The SDE_Universal_EventTypeDimension mapping extracts the data from file_event_type.csv and populates the W_EVENT_TYPE_DS staging table.
2. The SIL_EventTypeDimension mapping sources data from the staging table and passes it over to the Source Independent Load (SIL) mapping. The SIL mapping generates the surrogate key for each record in the staging table, then inserts it into W_EVENT_TYPE_D target table.