QuestionQ31

Data Integrity – Attributes and Sources for the Data

When creating a transform map that maps software installation data into the appropriate SAM table, why would you set the coalesce values for the u_display_name, u_publisher, u_version, u_installed_on, and u_assigned_to fields to true?

Choose two
  • A To ensure that you import all these fields into the table
  • B To avoid duplication of data
  • C To ensure completeness of data
  • D To ensure that if all fields match an existing record on import, that a new record is created
  • E To ensure that if all fields do not match an existing record on import, that a new record is created
Explanation

Coalesce fields form the matching key used during import. When all specified values match an existing target record, ServiceNow updates that record instead of creating a duplicate. When the coalesce values do not produce a match, ServiceNow creates a new target record. With multiple coalesce fields, every coalesce value must match to update an existing record.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!