When importing data intoServiceNow, anImport Setis created, and aTransform Mapis used to map data from the Import Set table to a target table (such asincident,cmdb_ci, oruser).
ATransform Mapdefineshow data from an Import Set is transferred to the target table. One of its key characteristics is that it can beused multiple times on the same import setto reprocess data or correct mapping errors.
Import Set Table:
Temporary storage for incoming data.
Data remains in the Import Set table until transformed.
Transform Map:
Areusable mappingthat determines how fields in the Import Set correspond to fields in the target table.
Can be runmultiple timeson the same Import Set data.
Coalesce Fields:
Usedbefore transformationto determine whether toupdate existing records or create new ones.
Key Characteristics of Importing Data in ServiceNow:
You import a CSV file into anImport Set Table.
You apply aTransform Mapto map data to theUser (sys_user) table.
If an issue occurs, you canrerun the Transform Map on the same Import Setinstead of reimporting the file.
Example Scenario:
A. An existing Transform Map can be used one time on the same import set– Incorrect.
Transform Maps can be reusedmultiple times on the same Import Set data.
B. Coalesce fields are used only after running Transform– Incorrect.
Coalesce fields are used before transformationto determine if a record should be updated or inserted.
C. Any user can manage and set up import sets– Incorrect.
Onlyusers with the appropriate roles(such asimport_adminoradmin) can manage Import Sets.
Explanation of Incorrect Answers:
ServiceNow Product Documentation → Import Sets and Transform Maps
ServiceNow CSA Study Guide → Data Import and Management
ServiceNow Knowledge Base → Understanding Coalesce Fields in Import Sets
References from Certified System Administrator (CSA) Documentation:
