Implementation Guide for Oracle Self-Service E-Billing > ETL Input File Specifications and Data Mapping >

About ETL File Processing

ETL processes two types of data files:

• Files to populate any new dimension information, including the following 3-character record types (REC_TYPE): 100, 110, 120, 130, 140, 150, 160, 170, 180, 190, 200, 210, 220, 230, 240, 250.
• Files to populate fact data into all the fact tables and some dimension tables, including the following 4-character record types (REC_TYPE): 0000, 1000, 1100, 1200, 1300, 2000, 2100, 3000, 3100, 3200, 3300, 3400, 3500, 4000, 4900, 5000, 5100, 9000, 9200, 9500.