Import Sets

Question 1

What roles are required to manage aspects of import sets?

Answer 1

admin role or import_admin role

Question 2

What is the use of an Import Set?

Answer 2

Import data from various data sources then map that data into ServiceNow tables

Question 3

How can I import data?

Answer 3

• Local source file (xml, csv, excel)
• Network server by providing path and authentication info
• LDAP connection
• JDBC connection
• OIDC
• REST (Integration Hub)
• Data Stream Integration Hub
• Custom (load by Script)

Question 4

Which label is used to name the Import Set table?

Answer 4

The Import Set table is named with the imported file label

Question 5

What is a Transform map used for?

Answer 5

• Move data from an Import Set table to a Target table.
• Transform map determines the relationships between the fields in the import set table and the fields in the SN target table

Question 6

Can a single field in the import set table be mapped to multiple fields in the target table?

Answer 6

Yes

Question 7

Which tables are a potential destination for transformation of an Import set?

Answer 7

Any table

We can only select:

• tables within the currently selected application scope
• tables in the global scope
• tables that grant write access to other applications

Question 8

Which fields in a destination table can serve as potential destination fields for transformation from an Import Set?

Answer 8

Any field

Question 9

Can a transform map be reused after it has been defined?

Answer 9

Yes

Question 10

What is the Automatic Mapping Utility used for?

Answer 10

Used when the fields in the Import Set table match all the fields in the target table.

Press Auto Map Matching Fields in the related list in the table transform maps form (??)

Question 11

What is data transformation?

Answer 11

The conversion of an Import Set table into its target table according to rules defined in the transform map

Question 12

What is a target table?

Answer 12

An existing table in the platform where the data will be placed post-transformation

Question 13

What happens during data transformation when the coalesce checkbox is selected in the field map?

Answer 13

The instance checks for existing records in the target table with the same value as the one in the import set field

Question 14

What happens if a match value (import set - target table) is found when the coalesce option has been selected?

Answer 14

The record is update with the imported data

Question 15

What happens when the value of the coalesce field in the target table does not match the value in the import set table?

Answer 15

A new record is inserted with the new data

Question 16

Why do we use coalesce fields?

Answer 16

In order to avoid duplicate records.

The coalesce field indicates to update records.

If no coalesce is defined, all imported records are treated as new records, and are inserted.

Question 17

How many configurations are there to coalesce imported data?

Answer 17

• No coalesce
• Single-field coalesce
• Multiple- field coalesce
• Conditional coalesce

Question 18

What happens if we choose the “No coalesce” option?

Answer 18

Every imported record is treated as a new record and is inserted.

No records are updated

Question 19

What happens if we choose “Single-field coalesce” option?

Answer 19

If a record in the target table exists with the same field value as in the import set table coalesce field, then the record is updated with the new record data.

Question 20

What happens if we choose “Multiple-field coalesce” option?

Answer 20

If a record in the target table exists with the same valueS as in in the import set coalesce fieldS, then the record is updated.

All the fields values in the target table must match the field values in import set for the record to be updated.

Question 21

What is conditional coalesce?

Answer 21

Conditional coalesce script defined in the field map for the sys_id field.

To update a record using the import table record values, the script must return the target table record sys_id

Question 22

What is a data policy?

Answer 22

A rule used to enforce data consistency by setting fields as mandatory and/or read-only

Question 23

How does data policies apply to tables and db relative to scope?

Answer 23

Can create data policies

• only for tables and db views that are in the same scope as he data policy
• for tables that have at least 1 field in the same scope as the data policy
• if the table is not in the same scope as the data policy, we can create data policy rules for fields that are in the same scope but cannot make a field mandatory

Question 24

Where to go to configure data policy?

Answer 24

All > System Policy > Rules > Data Policies

Question 25

Data policies can be applied to what type of data?

Answer 25

All data entered into the system, including,

• import sets, web services, data entered through UI Mobile

Question 26

Can data policies be opted out for import sets and web services?

Answer 26

Yes

Question 27

What happens when a data policy is applied to a list view to make a field read-only?

Answer 27

The field will appear to be editable but the update will fail.

Question 28

Where do we create an Import Set in the All menu?

Answer 28

All > System Import Sets > Load Data

Question 29

What role is required to populate the Load Data form in order to create an Import Set?

Answer 29

import_admin
OR
import_set_loader
OR
import_transformer

Question 30

Where to go in the All menu to create a Transform Map?

Answer 30

All > System Import Sets > Create Transform Map

Question 31

Where to go in the All menu to define a Coalesce field?

Answer 31

All > System Import Sets > Administration > Transform Maps

Question 32

Where to navigate in order to clean up an import set table?

Answer 32

All > System Import Sets > Import Set Tables > Cleanup