Skip to main content

Merge All Rows

Enable this setting to merge all data from a manually mapped source to a PSA table target, bypassing delta detection with rowhash diff comparison.

For a manually mapped load targeting a PSA table, enabling this removes the row-comparison predicates from the generated MERGE statement, so every source row is merged into the target instead of only rows whose compared values differ.

When to Change This Setting​

Keep the default N so manually mapped PSA loads only apply changed rows. Enable it when the comparison is not wanted — for example when the mapped source columns do not support a meaningful row comparison.

SettingInteraction
Truncate If Source Has RowsNot applied while all rows are merged
Delta Stage All RowsThe equivalent bypass on the staging side of the load

Notes​

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