Module 7.1 Flashcards
Understand what data is coming in and where is should be place before what?
Before importing any data
Plan time before an import to verify the data to correct inaccurate data and delete undesired or inaccurate data (t/f)
True
Why is it best to spend time planning and examining data before importing it?
To save time and potential problems later
What are the three ways that the guided application creator provides for creating tables?
Upload spreadsheet
Extend
Scratch
What option do you choose to easily transform an excel spreadsheet into a table?
Upload spreadsheet option
What are the two ways to upload a spreadsheet?
Manually or drag and drop
What requirements does the spreadsheet have to be successfully used?
Must be xlsx with horizontal columns and header labels
After you upload a spreadsheet what must you indicate?
Which rows contain header columns
What is the default row for the header column?
1
When a spreadsheet is uploaded what information is detected and extracted?
The field labels, the field names, and the field types
After uploading the spreadsheet, to include the data make sure you select what?
import the spreadsheet data
The system cannot identify choice or reference fields but what can be done?
It can be defined manually
The system will parse the first worksheet in the spreadsheet to do what?
To identify the fields for the custom table
Can new fields be added to a table after fields have already been imported?
Yes
How many field types are listed as options for new fields for tables?
18
If a field type for a table is not listed, what system property can be added for you to set value to the field type?
sn_g_app_creator.field_types
After table columns are defined, what is next to do?
Define the table properties and permissions
To finish designating tables when creating an app, what do you select?
Done with tables
If you do not use the import option during Guided Application creator, what provides a mechanism to pull data into servicenow?
Import sets
Where do import sets store data?
In import set tables
When does the import set process skip records?
when the data in the instance is the same as the data being imported
What determines the relationship between fields in an import set table to fields in an existing ServiceNow table?
Transform maps
This is the table where data will be placed, post transformation during an import set
The target table
What is the process for importing via an import set?
Load data, create transform map, run transform
When loading data into an import set table via excel, where is the data initially loaded before it’s final destination?
A staging table
When loading data into an import set table via excel, what is loaded onto the staging table?
All content from a worksheet
Does all data from a staging table have to be copied to the final destination?
No
Where do you first go to create a new import set table?
System import sets> load data > create table
How do you name an import set table?
The name field is automatically populated after putting a value in the label field
Maps data from the source (import set) table to the target table
Transform map
A set of field maps that determine the relationships between fields in an import set and fields in an existing servicenow table
Transform map
Once defined, can an existing transform map be reused for mapping data from an import set to a servicenow table?
Yes
To create a transform map, after importing data what do you select? (Two options)
Select the create transform map related link or create a transform map in studio
Select this to run business rules, workflows, approval engines, auditing, and field normalization while the transformation inserts or updates data into the target table
Run business rules
Select this to enforce mandatory fields on the target table when creating a transform map
Enforce mandatory fields
Choose this option to clear fields with existing values when an incoming field contains an empty value when creating a transform map
Copy empty fields
Choose this option to create a new record when all coalesce fields are empty when creating a transform map
Create a new record on empty coalesce fields
What are the two ways to match fields on the import set table to fields on the target table?
Automatic (if field names match)
Manual
The simplest method to match fields is where all of the field names of the import sets match the names of the fields on the target table. In this case, simply click?
Auto map matching fields in the related list in the table transform map and confirm proper matching
If there are any discrepancies in how fields are automatically matched this can easily be corrected by doing what?
Using the mapping assist utility
When all fields are matched properly, what do you select to begin transforming data onto the destination table?
Transform in the related list
Provides a visually intuitive environment for specifying mapping between import set fields and production table fields
Mapping assist utility
With this it is possible to map a single source field (field on an import set table) to multiple destination fields (fields on a production table)
Mapping assist utility
Can more than one field be a coalesce field?
Yes
Are coalesce fields required?
No
This option makes a field a record’s unique key
Coalesce
If a match is found using the coalesce field, the existing record will be updated with the information being imported. If a match is not found, then what happens?
A new record will be inserted into the database
The import set application attempts to match source values to existing target values when the coalesce value is set to what?
True
The import set application always creates new records for each transformation when the coalesce value is set to what?
False
If multiple fields are set to coalesce, all coalesce values are used to do what?
Match an existing record
If two fields are set for coalescing and a matching value is found on one of the coalescing fields but not on the other, what happens?
A new record is inserted
This copies data from the import set table to the target table using the map(s)
Transform
After a transform is complete what are the three options for the next steps?
-Go to the import set
-Show the transform history, related errors, and log
-View the import log
To transform data what do you select?
Select the transform related link
Select the import set to copy records from
Select the map(s) to use when copying
Select transform
