New and Improved Features

...

Anchor
PMP-95273 PMP-95273

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

...

• 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 previous years, customers should reach out to Ideagen support with a TA request.

...