Enhanced the Performance of Slowly Changing Dimension Execution

SCD execution has been enhanced to leverage the MEDIUM connection group, delivering significantly higher performance and faster processing for large-volume data workloads. When the number of records in the staging table for a given MISDATE reaches a threshold, the system automatically switches from the default LOW connection group to the MEDIUM connection group. This dynamic adjustment ensures efficient resource utilization and quicker execution times for high-volume scenarios.

SCD execution has been upgraded to utilize the MEDIUM connection group, delivering faster performance and reduced execution time for large-volume data processing. This improvement is particularly beneficial for environments handling substantial data volumes, enabling smoother and more scalable operations.

Steps to Enable

You don't need to do anything to enable this feature.