E.2 Derivations
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.
Commands to
execute:
<OFSAAI Installed Directory>/ingestion_manager/scripts/runUtility.sh <Utility
Name>
<OFSAAI Installed Directory>/ingestion_manager/scripts/runDL.sh <Utility
Name>These commands should be run serially. The utility has executed successfully only after
both of these commands have successfully executed.
Table E-1 Utilities
| Product | Utility Name | TableName | Predecessor |
|---|---|---|---|
| ECTC | EnergyAndCommodityFirmDailyDerived | EC_FIRM_DAILY | - |
| ECTC | EnergyAndCommodityMarketDailyDerived | EC_MARKET_DAILY | - |
| ECTC | EnergyAndCommodityTradeDerived | EC_TRADE | - |
| ECTC | EnergyFlow | ENERGY_FLOW | - |
| BC | MutualFundFamilyAccountPosition | MUTUAL_FUND_FAM_ACCT_PO SN | - |
| BC | RegisteredRepresentativeCommissionProfi le | RGSTD_REP_CMSN_SMRY | - |
| BC | RegisteredRepresentativeCommissionProd uctMixProfile | RGSTD_REP_CMSN_PRDCT_SM RY | - |
| ECTC | EnergyFlowDailyProfile | ENERGY_FLOW_SMRY_DAILY | EnergyFlow |
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