Usage of Intermediate Tables in the Engine for Management Ledger

11.8.9 Usage of Intermediate Tables in the Engine for Management Ledger

Ledger migration with Management Ledger tables uses intermediate tables. Intermediate tables can be Global Temporary tables or Normal tables. The creation of an intermediate table depends on the Application Preferences' Debug setting. If the Debug setting is - Do not output any message, then Global Temporary table is created. For any other debug setting, a normal table is created. Global Temporary table, which is created, gets dropped at the end of execution. Usage of a global temporary table will increase the performance of execution since data does not last after execution. Normal tables are not dropped at the end. To drop the tables, execute the purge script at regular intervals. All intermediate table names will start with zML_GTT_<process sys id>_<slno>. The naming convention is the same for both the global temporary table and the normal table. The <process sys id> is the process definition ID and <slno> is a number of the intermediate tables.

For migration of data from instrument table to ledger tables, three intermediate tables are used. For example:

zML_GTT_<process sys id>_1
zML_GTT_ <process sys id>_2
zML_GTT_<process sys id>_3