Previous | Page 3 of 3 | Next

ORDM 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 ORDM Base, Reference, and Lookup tables
• Intra-ETL among ORDM tables (such as from a Base table to a Derived table); for example:
  • The Base table DWB_RTL_SLS_Retrn_Line_Item feeds the Derived table DWD_RTL_SL_Retrn_Item_Day.
  • The Derived table DWD_RTL_SL_Retrn_Item_Day is used to populate the materialized view DWA_RTL_SL_Retrn_ITEM_WK_MV.

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