Expand my Community achievements bar.

We are excited to introduce our latest innovation to enhance the Adobe Campaign user experience — the Adobe Campaign v8 Web User Interface!

using composite key made up of email and mobile columns

Avatar

Level 1

Hi, As part of my campaign data import I always kept email field as unique. But now the Business requirement is to have a combination of email and mobile to be unique. I want to know how this change would affect my prior campaign workflows? what are the cons?Amy_WongWoojinDebbieclawsonmghalpinJochem van DietenAdobe CampaignMarilynlee17

1 Reply

Avatar

Employee

Hi rohitv20697926

Any sort of changes to the structure of a Database Schema would impact data retrospectively as well.

So if the primary key is being modified to a combination of multiple fields, the prior Workflows referencing that Schema would look for that composite key (unique) combination as well.