15.1 Objective

To optimize the end?to?end data flow and the need for intra?day reporting, institutions could load intra-day records into OFSAA. Current application can only handle one set of records per date (incremental loads are not possible).

1. Users need to adjust and reload data (either full or partial) for the current date.
2. Users need to adjust and reload data (either full or partial) for any of past dates.

3. Support incremental consumption of data from staging area.

   Note:

   The load run is enabled only in the model and is '0' by default in the model. This does not impact data previously available. The enhancements to the OFSAA batch and run framework to cover all the use cases will be taken in a future release.

OFSDF 8.1.2.0.0 staging model provides a flexibility to load multiple snapshots of the data in the staging tables (Product Processors). A column named n_load_run_id is introduced as part of the primary key of the product processor tables to enable this feature. However, the full fledged functionality to load and manage these snapshots will be part of the platform release at a later stage. In order to leverage this design in 8.0 release, the below mentioned changes should be performed as a workaround to load multiple snapshot of data from staging to results tables such as Fact Common Account Summary.

For Loading multiple snapshots of data for the same FIC_MIS_DATE, the existing T2T's should be executed through the Run Rule Framework . Additionally, the load should be filtered accordingly for each load run via the run filter.

To execute this run:

1. Navigate to $FIC_HOME/ficweb/webroot/conf
2. Edit the file: excludeURLList.cfg
3. Add the following entry at the end of the file: [SQLIA]./pr2

   Note:

   There should not be any blank line in the file.