E.2 Derivations

These utilities populate a single table in the data model.

These utilities populate a single table in the data model. They should be executed after all the files have been loaded. A utility should not be executed until its predecessors have executed successfully.

Execute the following commands:

<OFSAAI Installed Directory>/ingestion_manager/scripts/runUtility.sh <Utility Name>
<OFSAAI Installed Directory>/ingestion_manager/scripts/runDL.sh <Utility Name>

AccountDailySecurityProfile

The AccountDailySecurityProfile Utility is used to populate the Account Daily Security Profile table. This Utility reads the Trade table, and processes the trade records to populate the ACCT_SCRTY_SMRY_DAILY table.

Execute the following commands:

runUtility.sh <Utility Name>
runDL.sh <Utility Name>

While executing these commands, replace <Utility Name> with AccountDailySecurityProfile

Example:

 runUtility.sh AccountDailySecurityProfile 
runDL.sh AccountDailySecurityProfile