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




Last modified on Jun 9, 2020