CSA · Question #207
When importing data from a spreadsheet, which step defines where the incoming data columns will be written in the receiving table?
The correct answer is D. Create Transform Map. The Transform Map is the critical step during data import that defines how incoming data columns from the import set will be mapped and written to specific fields in the target table.
Question
When importing data from a spreadsheet, which step defines where the incoming data columns will be written in the receiving table?
Options
- ASchedule Transform
- BField Matching
- CSelect Data Source
- DCreate Transform Map
- ELoad Data
How the community answered
(64 responses)- B3% (2)
- C3% (2)
- D92% (59)
- E2% (1)
Why each option
The Transform Map is the critical step during data import that defines how incoming data columns from the import set will be mapped and written to specific fields in the target table.
Schedule Transform automates the execution of the transform process but does not define the data mapping itself.
Field Matching is a component or an outcome of creating a transform map, where the system attempts to auto-match fields, but the Transform Map record is the definitive location for these definitions.
Select Data Source identifies where the raw data originates but does not specify how its columns will be integrated into the target table.
A Transform Map explicitly defines the relationships between the source columns in an import set table and the target fields in a ServiceNow table. This map dictates which incoming data will populate which field in the receiving table, often including scripts for data manipulation during the transformation.
Load Data is the initial step of bringing data into a staging area (the import set table), occurring before any mapping or transformation to the final target table.
Concept tested: Import Set Transform Map
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.