How does DSP handle multiple source records matching a single target record?
DSP processes the target record iteratively — applying transformations from each matching source record in turn. Later updates overwrite earlier ones, producing a single final version of the target record before execution.
To process only one source record per matched target, use the
IS_FIRST_IN_ITERATION(...expressions)
function in a Scope Filter.
This ensures that only the first source record in each group is applied.