15.2 Design Details

Loading of data into OFSAA can be in any of the following ways:

ETL Tool

OFSAA F2T

OFSAA T2T

OFSAA Excel upload

OFSAA DIH

OFSAA data model includes load run identifier as part of the primary key for a set of staging tables. This enables data to be stored for multiple load runs for any date. OFSAA data model also has a table to maintain master information about load run and can be used for identifying or filtering load run during run execution within OFSAA.