# Choosing Extract, Turbo Extract, Load or Transform

*Omnistudio Consultant Study Guide · Data Mappers · Last updated October 27, 2026 · https://www.certifyforce.com/study-guide/omnistudio-consultant/data-mappers/choosing-extract-turbo-extract-load-or-transform*

Which of the four Data Mapper types fits a requirement: Turbo Extract for fast single-object reads with parent fields, Extract for child lists, formulas, defaults and XML, Load for writes with formulas, and Transform for reshaping data in memory with no SOQL.

- Certification: Salesforce Omnistudio Consultant
- Exam section: Data Mappers
- Study guide: https://www.certifyforce.com/study-guide/omnistudio-consultant

**Official exam objective:**

> Differentiate and recommend the correct Data Mapper type (Extract, Turbo Extract, Load, Transform) based on the specific business need.

## What the exam expects

- Recommend a Turbo Extract, Extract, Load or Transform from what the step must do: read, write or reshape, and with which extras.
- Explain why a Turbo Extract is the fast choice for one object plus parent fields, and name the needs that rule it out (child lists, formulas, default values, XML output, several apostrophe inputs).
- Recognise that Extract, Load and Transform all support formulas, so a calculation alone never forces an extra Data Mapper.
- Recommend a Transform when data is already in memory and no SOQL query may run.
- Confirm that Data Mappers read custom metadata types declaratively, with no Apex.

Key terms: **Interface Type** (the Data Mapper type, chosen at creation); **related objects** (parent fields a Turbo Extract selects); **extract step** (one object queried by an Extract); **Formula Result Path** (the node that holds a formula result); **Output Type** (the format a Data Mapper returns).

## Key facts

| Fact | Detail | Source |
|---|---|---|
| Turbo Extract reads | One object type plus fields from related (parent) objects | [Omnistudio Data Mappers](https://help.salesforce.com/s/articleView?id=xcloud.os_omnistudio_dataraptors_45587.htm&language=en_US) |
| Turbo Extract can't use | Formulas, custom JSON, default values, transformations | [Omnistudio Data Mappers](https://help.salesforce.com/s/articleView?id=xcloud.os_omnistudio_dataraptors_45587.htm&language=en_US) |
| Turbo Extract relationship depth | Up to five relationship levels, child-to-parent only | [Configure a Data Mapper Turbo Extract](https://help.salesforce.com/s/articleView?id=xcloud.os_configure_a_dataraptor_turbo_extract_45667.htm&language=en_US&type=5) |
| Turbo Extract LIMIT | 1 through 50000; default 50000 | [Configure a Data Mapper Turbo Extract](https://help.salesforce.com/s/articleView?id=xcloud.os_configure_a_dataraptor_turbo_extract_45667.htm&language=en_US&type=5) |
| Apostrophes in several inputs | Not supported on a Turbo Extract; use an Extract | [Configure a Data Mapper Turbo Extract](https://help.salesforce.com/s/articleView?id=xcloud.os_configure_a_dataraptor_turbo_extract_45667.htm&language=en_US&type=5) |
| Child record lists | Need an Extract with at least two extract steps | [When to Use Multiple Extract Steps](https://help.salesforce.com/s/articleView?id=xcloud.os_when_to_use_multiple_extract_steps_45967.htm&language=en_US&type=5) |
| Formula support | Extract, Transform and Load; Turbo Extract doesn't | [Use Formulas in Omnistudio Data Mappers](https://help.salesforce.com/s/articleView?id=sf.os_use_formulas_in_dataraptors_47540.htm&language=en_US&type=5) |
| Output Types | Extract JSON/XML/Custom; Turbo JSON/Custom; Load sObject; Transform adds PDF, Docusign, Document Template | [Designing Data Mappers for Optimal Performance](https://trailhead.salesforce.com/content/learn/modules/omnistudio-data-mapper-fundamentals/design-data-mappers-for-performance) |
| Transform and SOQL | Works in memory; no SOQL or other Salesforce reads | [Omnistudio Data Mappers](https://help.salesforce.com/s/articleView?id=xcloud.os_omnistudio_dataraptors_45587.htm&language=en_US) |
| Custom metadata | Readable by Data Mappers with no special syntax | [Omnistudio Data Mappers](https://help.salesforce.com/s/articleView?id=xcloud.os_omnistudio_dataraptors_45587.htm&language=en_US) |
| Load in Preview | Changes are saved permanently to Salesforce | [Understanding Data Mapper Types](https://trailhead.salesforce.com/content/learn/modules/omnistudio-data-mapper-fundamentals/explore-data-mapper-types) |

## Check yourself

- Why can't a Turbo Extract on Account return every related Contact on Standard Runtime?
- When should a consultant recommend a Transform rather than an Extract on Standard Runtime?
- Which Output Types can a Turbo Extract return?

## Sources

- [Omnistudio Data Mappers](https://help.salesforce.com/s/articleView?id=xcloud.os_omnistudio_dataraptors_45587.htm&language=en_US)
- [Configure a Data Mapper Turbo Extract](https://help.salesforce.com/s/articleView?id=xcloud.os_configure_a_dataraptor_turbo_extract_45667.htm&language=en_US&type=5)
- [Understanding Data Mapper Types in Omnistudio](https://trailhead.salesforce.com/content/learn/modules/omnistudio-data-mapper-fundamentals/explore-data-mapper-types)
- [Designing Data Mappers for Optimal Performance](https://trailhead.salesforce.com/content/learn/modules/omnistudio-data-mapper-fundamentals/design-data-mappers-for-performance)
- [Use Formulas in Omnistudio Data Mappers](https://help.salesforce.com/s/articleView?id=sf.os_use_formulas_in_dataraptors_47540.htm&language=en_US&type=5)
- [When to Use Multiple Extract Steps](https://help.salesforce.com/s/articleView?id=xcloud.os_when_to_use_multiple_extract_steps_45967.htm&language=en_US&type=5)
- [Relationship Notation versus Multiple Extract Steps](https://help.salesforce.com/s/articleView?id=xcloud.os_relationship_notation_versus_multiple_extract_steps_45995.htm&language=en_US&type=5)
- [When to Use Omnistudio Data Mappers and Integration Procedures](https://help.salesforce.com/s/articleView?id=xcloud.os_dataraptor_or_integration_procedure_8166.htm&language=en_US&type=5)
- [Omnistudio (Summer '24 Release Notes)](https://help.salesforce.com/s/articleView?id=release-notes.rn_omnistudio.htm&language=en_US&release=250&type=5)

## About the full unit

The "Core concepts", "Exam traps" and "Worked scenario" sections of this unit, its 10 linked practice questions, and unlimited timed mock exams are included with the Omnistudio Consultant pack (USD $19): https://www.certifyforce.com/practice-exams