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 Input and Output File Location on cloud

• Archive the input file(s) and upload the SQL Loader output files to the Input and Output File Location so they can be subsequently downloaded by the customer for review.