To extend a dimension create an Oracle Data Integrator mapping using the UDX table as source and target along with other source tables. The CM mapping updates the user defined fields (UDF?_CD and UDF?_DESCR) columns based on the input parameters and natural key of the UDX table.

After writing the package using the CM mapping, configure it and enable the jobs (Refer to the UDX Processing section in Chapter 4: Extending Star Schema). If data has already been loaded, the user-defined fields are populated for incremental changes. To load the data for all rows, reset the dimension using the reset scenario. Note that resetting a dimension resets the dependent facts also.