4 ETL Implementation and Customization

This chapter discusses the ETL (extraction, transformation and loading) programs you use to populate an Oracle Communications Data Model warehouse.

• The Role of ETL in Oracle Communications Data Model
  Describes source-ETL and Intra-ETL for Oracle Communications Data Model.
• ETL for the Foundation Layer of an Oracle Communications Data Model Warehouse
  ETL that populates the foundation layer of an Oracle Communications Data Model warehouse (that is, the base, reference, and lookup tables) with data from an operational system is known as source-ETL.
• Customizing Intra-ETL for Oracle Communications Data Model
  The Oracle Communications Data Model uses workflow implemented using PL/SQL packages to execute the intra-ETL process. The workflow consists of major components:
• Performing an Initial Load of an Oracle Communications Data Model Warehouse
  Performing an initial load of an Oracle Communications Data Model is a multistep process.
• Refreshing the Data in an Oracle Communications Data Model Warehouse
  To load new data into your Oracle Communications Data Model warehouse, you extract the data from one or more operational systems and copy that data into the warehouse.
• Managing Errors During Oracle Communications Data Model Intra-ETL Execution
  This topic discusses how you can identify and manage errors during intra-ETL execution.