Data Import Flashcards

(9 cards)

1
Q

A tool used to import data from various data sources, and map that data into ServiceNow tables

A

Import Set

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What are the processes in importing a set?

A

Data Sources
Import Set Table
Transform
Target Table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

A staging area for records imported from a data source

A

Import Set Table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Is a set of field maps that define the relationships between fields in an import set table and fields on a target table

A

Transform Map

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Means the field will be used as a unique key during imports

A

Coalescing a field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

T or F: If a match is found using the coalesce field(s), the existing record will not be updated with the information being imported

A

False. The existing record will be updated with the information being imported.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

T or F: If a match is not found using the coalesce field(s), then a new record will be inserted into the database

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

A rule that enforces data consistency by setting fields as mandatory and/or read-only.

A

Data Policy

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

T or F: Data Policies which have been configured for the table are applied when importing data.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly