Data Archival in Oracle Banking Payments
The Data Archival process involves the following steps:
- A date column TXN_ARCH_DT (Transaction Archival Date) get added to all the main Transaction-processing tables. This column denotes the transaction creation date.
- The partitioning of tables is implemented only based on the transaction creation date.
- To perform Interval Partition of the table, install the Partition Script. The Partition Script comes with each software release.
- In Partition Script, the time-frequency is set at three months interval. To change the Data Archival period, modify the Partition Script before installation.
- After installation of the Partition Script, all transaction data populates in appropriate partitions of the tables.
On existing data, a default conversion script also forms part of the Partition Script. The Partition Script contains a default clause to house the existing records. So, the default value populates in the TXN_ARCH_DT column. All the new transaction after software upgrade goes into new partitions
Parent topic: Data Archival in Oracle Banking Payments