Previous | Page 3 of 3 | Next

OADM 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 OADM Base, Reference, and Lookup tables
• Intra-ETL among OADM tables (such as from a Base table to a Derived table); for example:
  • The base table DWB_BKG_H feeds the derived table DWD_BKG_FACT via the PKG_DWD_BKG_FACT package. This package is implemented as PL/SQL package.
  • The base table DWB_FLT_SCHD_H feeds the derived table DWD_FLT_DETLS_FACT via the PKG_DWD_FLT_DETLS_FACT package. This package is also implemented as PL/SQL package.

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 OADM 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