Using SQL Loader When Processing Conversion Data Files
Processing of uploaded conversion data files is done via a Batch Process (for each staging table or MO) that does the following:
Prepares parameters for the SQL Loader process and retrieves Control File for an input table or MO
Invokes SQL Loader and processes the legacy data extract files that were uploaded to the dedicated File location on cloud
Archive the input file(s) and upload the SQL Loader output files to the File location so they can be subsequently downloaded by the customer for review.