Previous | Page 3 of 3 | Next

OCDM Architecture Overview

Predefined PL/SQL Scripts Perform ETL Among Levels

Predefined PL/SQL scripts are provided for two types of ETL:

• ETL from customer sources (typically OLTP systems) to OCDM Base, Reference, and Lookup tables
• Intra-ETL among OCDM tables (such as from a Base table to a Derived table); for example:
  • The base table DWB_WRLS_CALL_EVT feeds the derived table DWD_VOI_CALL_DAY via the DWD_VOI_CALL_DAY_MAP package. This package is implemented as PL/SQL package.
  • The base table DWB_WRLS_CALL_EVT feeds the derived table DWD_VOI_CALL_DAY via the DWD_VOI_CALL_DAY_MAP package. This package is also implemented as PL/SQL package.
  • The reference table DWR_ACCT is used to populate the table DWA_ACCT_DEBT_DAY.

In the diagram below, blue arrows signify ETL from sources, while red arrows signify Intra-ETL.

Depending on the type of customizations you will be performing against the standard predefined OCDM models, you may need to learn where to find specific scripts and modify them to reflect your customer's particular needs.

In other cases, you will simply create new scripts to define new objects or modify existing objects.

Previous | Page 3 of 3 | Next