Oracle^® Business Intelligence Applications Installation and Configuration Guide > Customizing the Oracle Business Analytics Warehouse > Type I Customizations: Adding Columns to Existing Fact or Dimension Tables >

Typical Steps to Extend Mappings in the Oracle Business Analytics Warehouse

The most common scenario for extending the data warehouse is to extract existing columns from a source and pass them through to an existing data warehouse table (either fact or dimension). This type of change generally requires extending an SIL mapping. If the data is coming from a packaged source, then you will also need to extend an appropriate SDE adaptor mapping. If the data is coming from a non-packaged source, then you must use a Universal adaptor mapping. (You will need to create a Universal adaptor mapping if an appropriate one does not already exist).

To extend a mapping in the Oracle Business Analytics Warehouse

1. Copy the mapping to a custom folder.
2. Extend the source and target tables by making changes to the tables in the database. You then import the source and target definitions into the custom folder (which replaces the existing definitions) or manually edit the existing definition.
3. Extend the SDE mapping by bringing in the additional columns.
   1. Either modify the Source Qualifier (which is an exposed object) to include the column in the SQL Override or add a lookup (which is a custom object).
   2. Connect objects to the placeholder transformation 'Exp_Custom'.
   3. Connect placeholder transformations to the target table.
4. Extend the SIL mapping by bringing in the additional columns.
   1. Modify the Source Qualifier (which is an exposed object) to include the column in the SQL Override.
   2. Add the column to the Source Qualifier and pass it through the filter to the 'Exp_Custom' transformation, to the Update strategy, and to the target.
5. Copy the workflow to the custom folder.
6. Update the DAC with the necessary changes.