5.3.9.3.6.2 Ledger Migration and the Virtual Memory Table
To calculate transfer rates at the Product dimension member level in the Management Ledger table, all rows in the Instrument tables must be accumulated to arrive at the Weighted Average Transfer Rate (WATR) and Weighted Average Add-On Rates (WAAR) for each member. All data used in the ledger migration process passes through a table, called the Virtual Memory table (VMT), and built in the memory.
This table exists only during the ledger migration process and the information is never written to disk, and thus it cannot be examined for problem-solving purposes. Understanding the operation of the VMT, however, is crucial to understanding the Ledger Migration Process.
The VMT comprises the following three types of columns:
- Organization Unit and Product dimension columns, which uniquely identify each row.
- Balance and WATR/WAAR columns to hold data accumulated from the Instrument tables.
- Balance and WATR/WAAR columns to hold data accumulated from the Management Ledger table and Instrument table calculations.