6 Purge Master

This topic explains the systematic instructions about Purge Master.

  1. On the Purge Generation screen menu, click on Purge Master.
    Preferences screen is displayed.

    Figure 6-1 Preferences


    Description of Figure 6-1 follows
    Description of "Figure 6-1 Preferences"

  2. On the Preferences screen, specify the fields
    For more information on fields, refer to the field description table.

    Table 6-1 Preferences

    Field Description
    Entity Description Specify a brief description of the entity that is are defining.
    Purge Type Select the purge type in the drop-down list:
    • Delete - The Data will be deleted from the main tables.
    • Archive - The data will be saved in the archive tables and deleted from the main tables.
    Purge Mode Select the mode of purge from the drop-down list:
    • Entity - Purge happens based on the entity or record.
    • Bulk - Purge happens in bulk for many records.
    Purge Frequency Select the frequency at which the purge should happen from the following options:
    • Ad-hoc
    • Daily
    • Weekly
    • Monthly
    • Quarterly
    • Yearly
    Archive Table Suffix Specify the text that should suffix the main table name during the archive purge operation. If the purge type is Archive, you must specify this. For example, if the name of the main table is MAIN_TABLE and you have specified the archive table suffix as HIST, then after the purge, the name of the archive table will be MAIN_TABLE_HIST.
    Archival Destination Select the archival destination from the following options:
    • Same Schema
    • Different Schema in same instance
    • Different Database