• Category 2
customizations use prepackaged adapters to add new fact or dimension tables to
the Oracle Business Analytics Warehouse.
• Category 2 customizations normally require that you build
new source-dependent extract (SDE) and source-independent load (SIL) objects.
In a Category 2
customization, you use prepackaged adapters to add new fact or dimension tables
to the Oracle Business Analytics Warehouse. Category 2 customizations normally
require that you build new SDE and SIL mappings.
A typical Category
2 customization involves building entirely new tables that will be loaded with
data from a source table that is not already extracted from. For example, you
might want to create a new PARTNER dimension table. In this case, you create
new dimension and staging tables as well as new extract and load ETL mappings.
In the
example in the slide, you would use the PARTNERtable in the source system to
capture data related to partners. You would then load the data into a new
dimension staging table and subsequentlya new dimension table in the data
warehouse.
No comments:
Post a Comment