Skip to main content

Truncate If Source Has Rows

Checks if the Persistent Staging Area (PSA) should be truncated if there is source data pending processing.

When active, the load truncates the PSA table when the staging source has rows to process and then loads the full set, replacing the delta processing — the delta-detection and current-row steps are omitted from the generated load. The setting is not applied for Snowflake targets, and it is inactive while Merge All Rows, Delta Stage All Rows, or Delta Is Late Arriving is enabled.

When to Change This Setting​

Keep the default N to accumulate history in the PSA. Enable it when the PSA for an object should only ever hold the latest received data set — each delivery then replaces the previous content.

SettingInteraction
Merge All RowsOverrides this setting when enabled
Delta Stage All RowsOverrides this setting when enabled
Delta Is Late ArrivingOverrides this setting when enabled

Notes​

  • This setting is part of the Staging Persistent settings category.
  • The default value for this setting is N.