QuestionQ22

VerifiedActivation

The Profile is configured with these attributes:

  • Email_address
  • firstName
  • lastName
  • CRM_id

Some customers do not supply email addresses, and some email addresses can be duplicated with different CRM id's. The client wants a file sent to the Email provider so customers can receive a promotional email.

Which option should the engineer select to ensure that only one record per email address is sent?

Explanation

Using Email_address as the sole deduplication key collapses all records that share an email address into one output record. Making that key mandatory excludes customers without an email address, which cannot be used to deliver the promotional email. Including a name or CRM_id in a composite key would allow duplicate email addresses whenever those additional values differ.

Community Discussion

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