Data Mappers17% of the exam
Data Mapper Load IDs, upserts, lookups and errors
How a Data Mapper Load decides between update and insert (record Id, single and multi-field Upsert Keys), which mapping settings handle nulls, lookups and linked objects, and which Load options control errors, assignment rules and value types.
Explain how Data Mapper Loads handle Salesforce ID mapping, upsert logic, and error management during data creation or updates.
~8 min read · 12 practice questions ·
What the exam expects
- Explain how a record Id in the input makes a Load update instead of insert, and recommend passing the Id from the Extract to the Load.
- Recommend single or multi-field Upsert Keys, Required for Upsert, Default Value, Disabled and Lookup mappings from a stated data rule.
- Recommend link mappings to relate parent and child records in one Load.
- Choose between Ignore Errors and Rollback On Error, and explain Use Assignment Rules (including guest users) and Delete On Success.
- Keep values valid on the way in: value substitution inside the Load and Output Data Types compatible with target fields.
Key terms: Upsert Key (a mapped field the Load matches on to update or insert); Required for Upsert (a null value blocks the update); Lookup (query by a field value and write the result); link mapping (copy a field from one Load object to a related one); Rollback On Error (create or update nothing if errors occur).
Key facts
Id in the input
- Detail
- The Load updates the record; no Id creates one
Several Upsert Keys
- Detail
- Form one multi-field upsert key
Multi-key match
- Detail
- The record must match all keys
Required for Upsert
- Detail
- A null value prevents the update
Default Value
- Detail
- Loaded when null; omit if Required for Upsert is on
Lookup
- Detail
- Queries by the field value and writes the result
Link mapping
- Detail
- Copies the parent's Id into the child's field in one Load
Ignore Errors
- Detail
- Skips only the failing steps
Rollback On Error
- Detail
- Creates or updates nothing if errors occur
Guest users
- Detail
- Can't trigger assignment rules
Output Data Type
- Detail
- Must be compatible with the target field, or the load can fail
- Why does a Load create a record instead of updating one when its input JSON has no Id?
- When does a Load with two Upsert Key mappings update an existing record?
- When should a consultant prefer Ignore Errors over Rollback On Error on Standard Runtime?
- Which kind of user can't trigger assignment rules even when Use Assignment Rules is selected?
The questions are free to read. Answers with their sources and self-grading are included with the pack.
Keep reading with the Omnistudio Consultant pack
- Core concepts
- Exam traps
- Worked scenario
The pack includes:
- All 31 lessons of the Omnistudio Consultant guide, with reading progress
- Interactive decision walks and step-by-step sequence steppers
- Inline practice questions and one-click topic practice (12 questions for this lesson)
- An official source cited for every claim
- An AI tutor that answers from the guide
- Unlimited timed practice exams