CAD · Question #242
Which set of steps is used to import spreadsheet data into a ServiceNow table?
The correct answer is B. Create Transform Map. Importing spreadsheet data into ServiceNow tables requires a structured process, with a key step being the definition of data mapping.
Question
Which set of steps is used to import spreadsheet data into a ServiceNow table?
Options
- ADefine Data Source, Select Transform Map, Run Transform Load Data.
- BCreate Transform Map.
- CRun Transform Select Import Set, Select Transform Map.
- DRun Transform Select Data Source. Schedule Transform
How the community answered
(43 responses)- A9% (4)
- B86% (37)
- C2% (1)
- D2% (1)
Why each option
Importing spreadsheet data into ServiceNow tables requires a structured process, with a key step being the definition of data mapping.
'Run Transform Load Data' is an inaccurate combination of steps; data is loaded into an import set first, and then transformed in separate, distinct phases.
A critical and distinct step in importing spreadsheet data into a ServiceNow table is to 'Create Transform Map,' which defines the field-to-field relationships and any necessary transformations between the import set (temporary staging area) and the target table. Without a properly configured transform map, the system cannot correctly process and map the incoming data to its destination.
The order of 'Run Transform' before 'Select Transform Map' is incorrect; the transform map must be defined or selected before the transformation can be executed.
'Run Transform Select Data Source' incorrectly conflates the data source definition with running a transform, and 'Schedule Transform' is an optional, later step, not part of the core import sequence.
Concept tested: ServiceNow data import process (Transform Maps)
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.