Management at Cloud Kicks wants to engage customers who have redeemed promotion codes on its website.
The associate set up a data extension so that Subscriber Key is the primary key. However, the associate notices that customers who have redeemed more than one promotion code only have one record added into the data extension.
What should the associate change to allow more than one record per subscriber key?
To allow more than one record per subscriber key, especially for customers who have redeemed more than one promotion code, the associate should assign the promotion code field as a second primary key. This creates a composite primary key consisting of the Subscriber Key and the Promotion Code field. With this configuration, each record is uniquely identified by the combination of the subscriber key and the promotion code, allowing multiple records for the same subscriber as long as the promotion codes are different.
Aimee
10 months agoYesenia
10 months agoHana
10 months agoLouvenia
10 months agoMirta
10 months agoRoy
11 months agoDierdre
11 months agoBobbye
11 months agoMalika
11 months agoBettye
10 months agoKeith
10 months agoAudry
10 months agoKeena
11 months agoMargret
11 months agoVallie
11 months agoAvery
12 months agoChauncey
11 months agoFidelia
11 months agoMaryann
11 months agoCletus
11 months agoChauncey
11 months agoGilma
11 months agoLavonna
11 months agoBeula
11 months agoGary
12 months agoSalina
1 years ago