Highlighted

using composite key made up of email and mobile columns

rohitv20697926

24-09-2018

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

Replies

Highlighted

Garima_Gakhar

Employee

26-09-2018

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.