ETL (extract, transform, load) to feed the ALM system (Focus) is a specific and particularised implementation of the generic concept of ETL.

The entry (extrac) of the module is a series of files without heading generated by the bank applications. And a file describing the set of files to be processed.

The transformation basically has five aspects

  • Accounts plan
  • Price curve
  • Discount curve
  • Foreign currency
  • Reporting attributes with the analysis dimensions for budgeting

Loading is made in the specific ALM Focus system in its entry structure InputDB.

From the point of view of users this type of converter will be used by two types of user:

  • Risk control
  • Budgeting