Real-Time Data Warehouse (RTDW) Optimizations

With the June 5 patch, two optimizations improve performance in the Real-Time Data Warehouse (RTDW).

Optimize Learning Object "transcript_curricula"

This enhancement applies to Cornerstone Learning organizations that are running curricula reports using the Reporting API, Data Exporter, and Replicated Data Warehouse (RDW). Optimized Learning object "transcript_curricula" improves the overall performance and stability of curriculum transcript reports. Data Exporter gains an optimized "Transcript_src_curricula_core" object that enables delta mode.

This functionality will be released with the 5 June 2020 post-release patch.

Optimize Cornerstone HR Object "forms2-submissions"

This enhancement applies to Cornerstone HR and Cornerstone Recruiting clients running forms reports using the Reporting API, Data Exporter, and Replicated Data Warehouse (RDW). To lessen the risk of ETL failure when generating forms data, the query used to update the “forms2-submissions” object is updated to only return question bank and custom fields used in a form (both published and non-published).

This functionality will be released in a post-release patch. It is not available during UAT.

Implementation

This functionality is automatically enabled for all organizations using RTDW.