When importing spreadsheet data into ServiceNow using the Import Set process, data is transferred in multiple stages. The step where data gets written to the receiving table is called "Run Transform." Import Set Process in ServiceNow:
Load Data: The spreadsheet or data file is uploaded to a temporary table (Import Set table).
Run Transform: The system processes the import set data and writes it to the target table.
Verify Data: After transformation, the data is checked for accuracy.
Explanation of Each Step:
Load Data:
The spreadsheet or external data is first imported into a staging table (Import Set table) in ServiceNow.
At this stage, the data is not yet written to the actual destination table.
Run Transform (Correct Answer):
The Transform Map applies field mappings and business logic.
The data is processed and written from the import set table to the target table (e.g., Incident, CMDB, or any other receiving table).
Any data transformation (such as field mappings, lookups, or script-based modifications) happens here.
Verify Data:
After transformation, users should validate the imported records to ensure that data was written correctly.
Why Other Options Are Incorrect?
B . Run Import:
This step only loads the data into a temporary Import Set table.
It does not write data to the receiving table.
C . Import Dataset:
"Import Dataset" is not an actual step in the ServiceNow data import process.
D . Execute Transform:
There is no "Execute Transform" step in ServiceNow.
The correct term is "Run Transform."
E . Schedule Transform:
While you can schedule transforms, this is not the step where data gets written to the final table.
The actual transformation and writing occur during "Run Transform."
Official ServiceNow Documentation Reference:
For more details, refer to the official ServiceNow documentation:
Importing Data into ServiceNow
Transform Maps in Import Sets