1. Implementation Guide
  2. Data Loads and Initial Batch Processing
  3. Data Requirements
  4. File Upload Samples
  5. Example #5: Multi-File Fact Data Load

Example #5: Multi-File Fact Data Load

Once you are confident in your data file format and contents, you may send multiple files as separate ZIP uploads for sequential loading in the same run. This process uses a numerical sequence on the end of the ZIP file name. You should still include the base ZIP file to start the process. The actual method to loop over these files is to use the RI_FLOW_ADHOC standalone flow in the AIF DATA POM schedule, which executes the fact history load for all the standard history load files.

Files to upload: RAP_DATA_HIST.zip, RAP_DATA_HIST.zip.1, RAP_DATA_HIST.zip.2, RAP_DATA_HIST.zip.3

Zip file contents (in each uploaded zip):

  •  SALES.csv

  •  SALES.csv.ctx – The CTX is only required in the first ZIP file, but it’s best to always include it so you can refer to it later in archived files, if needed.

In this example you are loading sales month by month iteratively, but the standalone flow supports all other fact loads as well. You can also combine multiple fact files (for different facts with the same period of time) in each ZIP file upload. Track the status of the files in the C_HIST_FILES_LOAD_STATUS table after each cycle execution; it shows whether the file was loaded successfully and how many more files are available to process.