ServiceNow CSA - Import Sets Questions and Answers Latest Updated 2022

Document Content and Description Below

ServiceNow CSA - Import Sets Questions and Answers Latest Updated 2022 What is an Import Set? ✔✔A tool used to import data from various data sources, and Map that data into ServiceNow tables. ... Which roles can manage all aspects of Import Sets? ✔✔admin and import_admin What are Data Sources? ✔✔Records in ServiceNow that contain information regarding an Import Set data source. Where can data come from for an Import Set? ✔✔(1) File (i.e. XML, CSV, Excel) (2) LDAP connection (3) JDBC connection What is an Import Set Table? ✔✔It acts as a staging area for records imported from a data source. What are Transform Maps for? ✔✔They provide a guide for moving data from Import Set tables to "target" tables; field mapping provides direct field-to-field data moves. Can you reuse Transform Maps? ✔✔Yes. Once defined existing Transform Maps can be reused for mapping data from an Import Set to a ServiceNow table. What is a Target Table? ✔✔An existing table in where the data will be placed, post-transformation of an Import Set. When should you review the accuracy of the data you are importing and why? ✔✔You should remove obsolete data and correct errors before import, as fixing after import takes much long. Why are large data imports discouraged? ✔✔Creating an extremely large Import Set can cause extensive delays. Can you use an existing Import Set Table? ✔✔Yes. What happens if you use an existing Import Set Table, but the data being imported has additional fields? ✔✔These new additional fields are added to the Import Set Table. How are the fields on the Import Set Table usually created? ✔✔They are automatically created based on imported data. What Data Sources can be loaded into an Import Set Table? ✔✔(1) JDBC (2) HTTP / FTP (3) EXCEL (4) CSV (5) XML How easy or complex is using a Transform Map? ✔✔It is flexible. The specification can be as simple as having the application automatic field names from source and destination, or mapping can use advanced logic and leverage the full power of the ServiceNow scripting environment. Can a field in an Import Set be mapped to multiple fields on a Target table? ✔✔Yes. [Show More]

Last updated: 1 year ago

Preview 1 out of 3 pages