|
Installation Guide for Oracle Self-Service E-Billing > Installing the ETL Module for Oracle Self-Service E-Billing >
Running the ETL Loader Job Using Sample Data
The ETL module is now ready to load data. Sample data is provided with Oracle Self-Service E-Billing for testing purposes. This task is a step in Roadmap for Installing the ETL Module for Oracle Self-Service E-Billing. To run the ETL Loader job using sample data
- If you are using the Telco version of Oracle Self-Service E-Billing, then copy the sample data files from the following directory to the ETL input directory. In the path, EDX_HOME is the location where Oracle Self-Service E-Billing is installed.
- UNIX.
EDX_HOME\db\oracle\olap\etl\sample_data\Telco
- Windows.
EDX_HOME/db/oracle/olap/etl/sample_data\Telco
Move the following sample Telco data files:
- MASTER-DATA-FILE-20100509.DAT
- EBILLING_B2B-DATA-FILE-20100510.DAT
- EBILLING_B2B-DATA-FILE-20100512.DAT
- EBILLING_B2B-DATA-FILE-20100551.DAT
- EBILLING_B2B-DATA-FILE-20100552.DAT
- EBILLING_B2B-DATA-FILE-20100553.DAT
- EBILLING_B2B-DATA-FILE-20101101.DAT
- EBILLING_B2B-DATA-FILE-20120528.DAT
- EBILLING_B2B-DATA-FILE-20120618.DAT
- EBILLING_B2B-DATA-FILE-20120630.DAT
- EBILLING_B2C-DATA-FILE-20100516.DAT
- EBILLING_B2C-DATA-FILE-20101101.DAT
- EBILLING_B2C-DATA-FILE-20120528.DAT
- EBILLING_B2C-DATA-FILE-20120618.DAT
- EBILLING_B2C-DATA-FILE-20120630.DAT
For consistency, it is recommended that you create the input directory in the same directory as the file locations previously defined in Oracle Warehouse Builder Design Center.
- If you are using the Utility version of Oracle Self-Service E-Billing, then copy the sample data files from the following directory to the ETL input directory:
- UNIX. EDX_HOME
\db\oracle\olap\etl\sample_data\Utilities
- Windows.
EDX_HOME/db/oracle/olap/etl/sample_data/Utilities
Move the following sample Utility data files:
- MASTER-UTILITIES-20110101.DAT
- EBILLING_B2C-UTILITIES-20110101.DAT
- EBILLING_B2C-UTILITIES-20120528.DAT
- EBILLING_B2C-UTILITIES-20120618.DAT
- EBILLING_B2C-UTILITIES-20120630.DAT
For consistency, it is recommended that you create the input directory in the same directory as the file locations previously defined in Oracle Warehouse Builder Design Center.
- Log in to the Oracle Warehouse Builder Design Center as the repository owner. Start the Control Center from the Tools menu.
- Select Tools, Preferences, OWB, and then Deployment Menu. Make sure the Prompt for execution parameters option is enabled.
- Expand the EBILLING_ETL_LOCATION, ETL_PF_MODULE, and ETL_SUP nodes.
- In the Command Center, run the HierarchyCopy job to the period specified in the data file. Also run the Hierarchy Copy job if the new load file, sample or real data, is for a new period.
For details on running the HierarchyCopy job, see Administration Guide for Oracle Self-Service E-Billing.
- Right click the EBILL_DATALOAD node (the ETL Loader job), and click Start. A dialog box might appear stating that the object must be deployed before execution. If this dialog appears, then click OK. Or you can run the ant command again from the following directory:
- UNIX.
EDX_HOME/db/oracle
- Windows.
EDX_HOME\db\oracle
- You must remove sample data before going live. For information about the process of purging sample data, see Administration Guide for Oracle Self-Service E-Billing.
CAUTION: You must remove sample data from your production environment to comply with the Payment Card Industry Data Security Standard.
- You must run the master key update script, which updates the master key as well as related subkeys and validation code in the Oracle Self-Service E-Billing database. The master key is used when setting up the OLTP and OLAP databases. For instructions on running the master key update, see Administration Guide for Oracle Self-Service E-Billing.
CAUTION: You must run the master key update after loading sample data to comply with the Payment Card Industry Data Security Standard.
|
