JDBC Data Sources With “Use last run datetime” Option Unchecked

< 1 min read

Impact Area

Performance

Severity

Warning

Affected Element

All

Rule ID #

SN-0093

Impact #

Repeatedly importing data that has not changed leads to many skipped rows and unnecessarily bounds system resources.

Remediation #

Ensure that each import is not importing all records every time by using the “Use Last Run Datetime” option. If you are running a JDBC import, use the last run datetime option in your import set Data Source. For a type of File import, be sure that whatever is generating your files is only adding data that is new, or has been changed.