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.