onBefore Transform Scripts should only update the target table
Impact area
Performance
Severity
High
Affected element
Transform script
Rule ID
SN-0171
Impact
Updates on other tables from onBefore Transform Scripts will be committed even if the update on the target table fails. This can cause data inconsistencies. Even if successful, the source of the update on the other table may become confusing.
Remediation
Avoid updating other tables on onBefore Transform Scripts.
Time to fix
15 min