Bookshelf Home | Contents | Index | PDF     

Implementation Guide for Oracle Self-Service E-Billing > 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
  • Files to populate fact data into all the fact tables and some dimension tables, including the following 4-character record types (REC_TYPE)s: 0000, 1000, 1100, 1200, 2000, 2100, 3000, 3100, 3200, 3300, 3400, 4000
    
Implementation Guide for Oracle Self-Service E-Billing Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices.