Archive retention period
xMart has always archived updated or soft deleted records when the MERGE load strategy is used (but not when REPLACE OR APPEND are used).
A new retention period is now available, per storage table, which optionally puts a time-limit on the retention period for archived data.
In the test environment, the default for this setting will be 7 days. In the production environment, the default for this setting will effectively be infinite (999,999 days).
Users are encouraged to reduce this setting to 0 if they do not require archival of old, updated or soft-deleted data. The setting is available on the Table Settings tab in the Model area and is set by table.
.
The retention period will be encouraged by sys admins for tables which do not need archived data and for “run away” tables which steadily increase by the number of their current rows.
There is a system-level default Archive Retention Period which is not set in Prod but is set to 30 days in UAT. If the value is set at table level then it overrides the system value.