Data Import and Management Flashcards
7 cards from real CSA practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Data Import and Management flashcards as text
What is the primary purpose of a Transform Map in ServiceNow data imports?
Answer: To map source fields to target table fields during import
A Transform Map defines how fields in the import set (staging table) map to fields in the target ServiceNow table.
Which scripting field in a Transform Map runs logic before any row is transformed?
Answer: onStart
The onStart script runs once before processing begins, making it ideal for initialization logic.
An import set source type of 'JDBC' allows ServiceNow to:
Answer: Connect directly to an external relational database
JDBC data sources enable ServiceNow to connect directly to external relational databases using a database driver.
What happens to records in an import set table after the transform is complete by default?
Answer: They are automatically deleted after 7 days
By default, import set records are cleaned up after 7 days, but this retention period is configurable.
Which field on a Transform Map record controls whether duplicate records in the target table are updated or skipped?
Answer: Coalesce field
Coalesce fields act as match keys — if a target record with the same coalesce value exists, it is updated rather than a duplicate being created.
The 'Run as' field on a scheduled import determines:
Answer: The user context under which the transform executes
The 'Run as' field specifies the user account whose permissions and roles govern the transform execution.
What does setting 'Copy empty fields' to true on a Transform Map do?
Answer: Overwrites target field values with blank when the source field is empty
When 'Copy empty fields' is true, blank source values will overwrite existing data in the target record's fields.