5.3.3 Executing the Historical Rates Data Loader T2T

You can launch the Historical Rates Data Loader from the following:

• Interest Rates Summary page
• PL/SQL block
• Operations Batch

1. To launch from the Interest Rates Summary page:
   • Click the Data Loader icon on the Interest Rates Summary grid toolbar.
   • A warning message will appear: Upload all available Interest Rates and Parameters?
   • Click Yes. The process will load all valid data included in the staging table.

   There are four pre-defined T2T mappings configured and seeded in OFSAA for the purpose of loading historical rates. These can be executed from the Batch Maintenance within OFSAAI.

   To execute the Historical Exchange Rates Data Loader, create a new Batch and specify the following parameters:

   • Datastore Type: Select appropriate datastore from the drop down list
   • Datastore Name: Select appropriate name from the list. Generally it is the Infodom name.
   • IP address: Select the IP address from the list
   • Rule Name: T2T_EXCHANGE_RATE_HIST
   • Parameter List: No Parameter is passed. The only parameter is the As of Date selection which is made when the process is executed.

   To execute the Historical Interest Rates Data Loader, create a new Batch and specify the following parameters:

   • Datastore Type: Select appropriate datastore from the drop down list
   • Datastore Name: Select appropriate name from the drop down list
   • IP address: Select the IP address from the list
   • Rule Name: T2T_IRC_RATE_HIST
   • Parameter List: No Parameter is passed. The only parameter is the As of Date selection which is made when the process is executed.

   To execute the Historical Term Structure Parameter Data Loader, create a new Batch and specify the following parameters:

   • Datastore Type: Select appropriate datastore from list
   • Datastore Name: Select appropriate name from the list
   • IP address: Select the IP address from the list
   • Rule Name: T2T_IRC_TS_PARAM_HIST
   • Parameter List: No Parameter is passed. The only parameter is the As of Date selection which is made when the process is executed.

   To execute the Historical Economic Indicator Data Loader, create a new Batch and specify the following parameters:

   • Datastore Type: Select appropriate datastore from the drop down list
   • Datastore Name:: Select appropriate name from the drop down list
   • IP address: Select the IP address from the list
   • Rule Name: T2T_ECO_IND_HIST_RATES
   • Parameter List: No Parameter is passed. The only parameter is the As of Date selection which is made when the process is executed.

   After executing any of the above batch processes, check the T2T component logs and batch messages to confirm the status of the data load.

   The T2T component can fail under the following scenario:

   • Unique constraint error: Target table may already contain data with the primary keys that the user is trying to load from the staging area.