QuestionQ10

Data Ingestion

A company gathers data through a web form on its website. It wants to combine the form data and deduplicate it against current customer data:

Company existing profile data:

  • companyEmail: [email protected]
  • fName: Celeste
  • lName: Brown-Smith
  • officePhone: 555-555-7787
  • mobilePhone: 555-555-1212
  • companyName: Blue Widget Company
  • companyPosition: Manager

Data submitted from the web form:

  • companyEmail: [email protected]
  • fName: Celeste
  • lName: Brown-Smith
  • officePhone: 555-555-7700
  • mobilePhone: 555-555-1212
  • companyName: Blue Widget Company
  • companyPosition: Director

Assume deduplication uses the composite key companyEmail + lName + mobilePhone, and that the new web-form data overrides the current data.

Which entry will the export file contain?

Explanation

The matching composite key identifies the records as duplicates, so the export contains one record. Since the incoming web-form record takes precedence, it retains companyPosition as Director and officePhone as 555-555-7700.

Community Discussion

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