---
title: onBefore Transform Scripts Should Only Update The Target Table
description: "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…"
url: "https://community-staging.qualityclouds.com/qcdocs/qcr/rules/onbefore-transform-scripts-should-only-update-the-target-table/"
updated: "2025-03-21"
category: Rules
---

# 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