Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-18992

Modify Forecast Aggregation to use CDC table for tbTransactionItem

    Details

    • Type: Improvement
    • Status: Ready for Developer (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: CFA 2022R2
    • Fix Version/s: None
    • Component/s: Forecasting
    • Labels:
      None

      Description

      As a developer, I would like to make use of the Change Data Capture (CDC) table created by RDS for the tbTransactionItem table to more easily update the Forecasting Metric Detail tables than the existing Forecast Aggregation process.

      At a high level, the existing Forecast Aggregation process takes a high watermark and processes all transactions between that high watermark and later to be aggregated into the various Metric Detail tables. Instead of using the high watermark to look at the transactional tables, it would use less resources and cause less contention to go against the CDC tables instead.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              Corey.Amend Corey Amend (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:

                PagerDuty

                Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.