CSA · Question #100
When importing spreadsheet data into ServiceNow, in which step does the data get written to the receiving table?
The correct answer is D. Execute Transform. When importing spreadsheet data into ServiceNow, the data is written to the receiving target table during the 'Execute Transform' step.
Question
When importing spreadsheet data into ServiceNow, in which step does the data get written to the receiving table?
Options
- ARun Transform
- BRun Import
- CImport Dataset
- DExecute Transform
- ESchedule Transform
How the community answered
(32 responses)- A3% (1)
- B3% (1)
- D88% (28)
- E6% (2)
Why each option
When importing spreadsheet data into ServiceNow, the data is written to the receiving target table during the 'Execute Transform' step.
'Run Transform' is essentially the same action as 'Execute Transform', but 'Execute Transform' can be seen as a more precise description of the process where the transformation logic is actively performed.
'Run Import' typically refers to the initial loading of data from the source file into the import set table, not the subsequent writing to the target table.
'Import Dataset' refers to the action of bringing the raw data into the staging (import set) table, which precedes the transformation to the target table.
In the ServiceNow data import process, after a spreadsheet's data is loaded into an import set table, the 'Execute Transform' step is where the transform map is applied. This mapping process reads the data from the import set table, manipulates it as defined, and then writes it into the final target table in the platform.
'Schedule Transform' sets up the transform map to run at a future time, but it is not the step where the data is actually written to the target table.
Concept tested: Data import transform step
Source: https://docs.servicenow.com/bundle/utah-platform-administration/page/administer/import-sets/concept/c_ImportSets.html
Topics
Community Discussion
No community discussion yet for this question.