Coalesce is a property of a field that we use in transform map field mapping.When we set the coalesce as true for a field mapping it signifies that this field will work as unique key.If a field match is found with the coalesce field, then existing record will be updated with the imported information in target table else a new record will be inserted into the target table
LDAP is Lightweight Directory Access Protocol.It is used for user data population and User authentication. Servicenow integrates with LDAP directory to streamline the user log in process and to automate the creation of user and assigning them roles
Import Sets is a tool used to import data from various data sources and, then using transform map, map that data into ServiceNow tables. The Import Sets table acts as a staging table for records imported.
A transform map transform the record imported into servicenow import set table to the target table. It also determines the relationships between fields displaying in an Import Set table and fields in target table
A foreign record insert occurs when an import makes a change to a table that is not the target table for that import. This happens when updating a reference field on a table.