Hierarchy Developer's Guide for Oracle Self-Service E-Billing > Working With the ETL Process >

ETL Processing

During ETL processing, accounts, service agreements (for example, MTNs or MSISDNs) and other business object dimension data and fact data are loaded into the OLAP database. In addition, an ETL exchange table (EDX_RPT_ETL_XCHANGE), which captures information about accounts, service agreements, companies and billing hierarchies, is populated and used to load corresponding production tables in OLTP database.

OLTPProductionLoader is one of steps in the ETL process, which loads different business objects from OLAP database tables, including Hierarchy Manager, into OLTP database production tables.

The following diagram illustrates this process.

Among account and service loaders, which populate account and service agreement tables to OLTP production (step 7), Hierarchy Manager ETL loader reads hierarchy information from EDX_RPT_ETL_XCHANGE table and populates Hierarchy Manager tables. While the changes are made to Hierarchy Manager in OLTP tables, the same changes are pushed into OLAP hierarchy tables as well.