New and Improved Features

Configurable

• No Items

Product Level Change

• PMP-97867 Sustainability DataMart Incremental Loading Performance Improvement Changes

PMP-97867 Sustainability DataMart Incremental Loading Performance Improvement Changes

Configurable: No

• Title: NA
• Public/Private: NA
• Default: NA

Existing System: 

• The Datamart incremental job captures data change for all historical years.

• However with increasing customer data and cases of Location, level remapping, incremental job is not able to process all years data change because of huge data volume.

• In such cases the job keeps running for hours causing over lap with other jobs and fails and causes data issues

Purpose: 

• Decrease data inconsistence in case of data recalculation

Enhanced System:

• Moving forward the incremental data mart refresh job with refresh only current and previous 2 years data.

• This is done with an assumption that usually any report and data comparison is done for previous 2 years in most of the cases
• In case data recalculation should be done for all years, customers should reach out Ideagen support with a TA request.

Impacts: No Impact

Back to top