QuestionQ9

Data Ingestion

A customer configures a destination with deduplication enabled for phone number and has two customer records displayed as follows:

Customer 1

  • Email: [email protected]
  • Phone: 555 124 1234
  • First Name: Mary
  • Last Name: Jones
  • Create Date: 2//2/2012

Customer 2

  • Email: [email protected]
  • Phone: 555 124 1234
  • First Name: Mary
  • Last Name: J
  • Create Date: 2//2/2021

What will the destination file contain?

  • A Email, Phone, First Name, Last Name, Create Date[email protected], 555 124 1234, Mary, Jones, 2//2/2012[email protected], 555 124 1234, Mary, J, 2//2/2021
  • B Email, Phone, First Name, Last Name, Create Date[email protected], 555 124 1234, Mary, J, 2//2/2021
  • C Email, Phone, First Name, Last Name, Create Date[email protected], 555 124 1234, Mary, Jones, 2//2/2012
Explanation

When phone number is the deduplication key, records with the same phone number are emitted once. The retained record is the most recently created matching record, so the row contains Customer 2’s email, phone, first name, last name, and Create Date.

Community Discussion

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