1. User Guide
  2. Data Loaders
  3. Transaction Summary Table Loader
  4. Dependencies

5.10.4 Dependencies

  • Instrument tables should be loaded before loading the transaction summary information related to those instruments.
  • Account Number is an alphanumeric unique identifier within each staging transaction summary tables. ID_NUMBER is a numeric unique identifier within processing transaction summary tables. Hence, there is a need to look up into a DIM_ACCOUNT dimension table for a numeric surrogate key for each of the alphanumeric account number. This dimension table DIM_ACCOUNT will be populated as part of the process that loads instrument tables. For more information on loading instrument tables, see Loading Instrument Table Data.
  • Before executing T2T data movement tasks, user should ensure that all the dimension tables that are required for instruments data are loaded. The following are some of the mandatory dimensions:
    • DIM_ACCOUNTS
    • DIM_PRODUCTS_B
    • DIM_GENERAL_LEDGER_B
    • DIM_COMMON_COA_B
    • DIM_ORG_UNIT_B