Multiple customer records with same email address
Overview
If an event arrives and there are multiple customer records with the same email address, then Connect must determine which of these customer records should receive the event.
Assume that there are three customers in the Connect database with the same email address: [email protected]. The customers have the following subscription status:
|
Customer_id |
Active_email_address |
Subscription status to “conv” |
|
1002 |
No Corresponding Record in CUST_SUBSCRIPTION |
|
|
1005 |
Subscribed(5) |
|
|
1007 |
Subscribed(5) |
Result
An email is sent to customer 1005.
Note: Connect picks up the customer with the oldest subscription and the lowest customer_id. In this case, customer 1002 is not subscribed to anything so the next lowest customer ID is 1005.