Match links source records with their corresponding target records, determining how each action should be applied. It's central to Insert, Update, Upsert, Merge, Delete, and Undelete operations — ensuring records are routed and processed correctly.

How Match works:

• Record Matching — Compares source records to target records using the Target Matching Field.
• Insert Logic — When a Target Matching Field is defined, records are inserted only if no match exists; without one, inserts proceed unconditionally.
• Multi-Field Matching — DSP supports a single Target Matching Field, but multi-field matching can be achieved through transformations such as VLOOKUP .
• Sorting & Selection — Matches can be sorted, and the Principal Matched Record Selection Rule controls whether the action runs on the first match or on all matches.
• Merge Matching — In Merge operations, the Principal Matched Record becomes the Master Record used to consolidate duplicates.