Hierarchy Developer's Guide for Oracle Self-Service E-Billing > Hierarchy Manager Concepts >

ETL Processing

During ETL processing, accounts, service agreements (such as MTNs or MSISDNs) and other business object dimension data and fact data are loaded into the OLAP database. In addition, the 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.

Figure 10 illustrates ETL processing.

Figure 10. ETL Processing

Among account and service loaders, which populate account and service agreement tables to OLTP production (step 7 in the diagram), Hierarchy Manager ETL loader reads hierarchy information from the 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. For additional information about setting up and using the ETL process, see Implementation Guide for Oracle Self-Service E-Billing and Administration Guide for Oracle Self-Service E-Billing.