15 Loading Multiple Load Runs in OFSAA

This chapter provides information about Loading Multiple Load Runs in OFSAA in the Oracle Financial Services Data Foundation application and step-by-step instructions to use this section.

Topics:

Objective

Design Details

Implementation

Loading OFSAA Staging Tables

Post Stage Load Process

Loading Data into OFSAA Results Tables from Staging Tables

Multiple load run enables data to be loaded multiple times during the day for staggered processing of data by analytical applications. The degree of complexity of data required by analytical apps vary from one to the other, the load run ensures that the customer can process the data as soon as it is ready for an app to uptake. This reduces the turnaround time to reporting, by avoiding the 'end of day' type of processing of information as part of the original design.

Note:

As a work around, currently you can use the following methods to load the results table using different Load Run IDs.