Enable End Date
Apply end dating in the PSA. This will allow timelines to be maintained in the PSA. Using end dating requires more resources since updates are applied on the PSA, but allows queries to directly reuse complete effective from and to dates for each record in the PSA. Disable this to configure an insert-only approach for the PSA for optimized load performance.
When enabled, together with history persistence, the RowEffectiveToDate and RowIsCurrent system columns are included on the Staging and PSA tables, and the generated PSA load adds an update statement that end-dates the previous version of each changed record and maintains the current-row flag. Records that are current carry a platform-appropriate high date (9999-12-31) as their effective-to date.
When to Change This Setting
Keep the default N for an insert-only PSA with the fastest possible loads; timelines are then derived at query time. Enable it when PSA consumers need ready-to-use effective from/to dates and current-row flags on each record.
Related Settings
| Setting | Interaction |
|---|---|
| Persist History | History persistence is required for end dating to apply |
| Delta Collapse Rows | Affects how the end-dating update is wrapped in the generated load |
Notes
- This setting is part of the Staging Persistent settings category.
- The default value for this setting is
N.