CH4: Import Data Flashcards
An ______________ is a tool used to import data from various data sources, and map that data into ServiceNow tables.
Import Set
True or False: Any user logged in with the admin or Import_admin role can manage all aspects of import sets.
TRUE
______________ are records in ServiceNow that contain information regarding an Import Set data source.
Data Sources
The _____________ acts as a staging area for records imported from a data source.
Import Set Table
____________ provide a guide for moving data from Import Set tables to “target” tables.
Transform Maps
True or False: A transform map is a set of field maps that determine the relationship between fields in an Import Set and fields in an existing ServiceNow table.
TRUE
The ________ is an existing table where the data will be placed, post-transformation.
Target Table
True or False: Data should be imported in extremely large chunks.
FALSE
True or False: Creating an extremely large import set can cause extensive delays.
TRUE
True or False: The imported file label is used to determine the name for the Import Set table that data will be loaded into.
TRUE
True or False: It is impossible to schedule imports.
FALSE
True or False: It is possible to choose an existing Import Set table to use for loading data from the same source, or data that has the same field/column designations.
TRUE
A ____________ is a set of field maps that define the relationships between fields in an import set table and fields in a targe table.
Transform Map
To _________ a field means that the field will be used as a unique key during imports.
Coalesce
True or False: If a match is found using the coalesce field(s), the existing record will be updated with the information being imported.
TRUE