Day - 5 ServiceNow Interview Questions - 5
What is the import set in ServiceNow and explain?
Ans)
---> Import sets enable administrators to import data from various data sources, and then map that data into ServiceNow tables. The import sets table acts as a staging area for records imported from a data source.
---> A transform map determines the relationships between fields displaying in an import set table and fields in an existing ServiceNow table, such as the Incidents or Users table.
Data source:
1) Excel
2) CSV
3) XML
4)JDBC
5) LDAP
6) HTTP
7) FTP
steps
1️⃣Create a Data Source for importing records
2️⃣Load data into a staging table
3️⃣Create a Transform Field Map
4️⃣Auto Map Matching Fields
5️⃣Mapping Assist
6️⃣Change or set field values using a Transform Map script
7️⃣Use a Transform Event script to update but not insert record
Coalesce field:
This will avoid duplicate record entry, If the same record is found means just updates the changes value fields.
follow me at: https://www.linkedin.com/in/palanivel-jayashankar/
