using composite key made up of email and mobile columns

Avatar

Avatar
Level 1
rohitv20697926
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
rohitv20697926
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
View profile
rohitv20697926
Level 1

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

Avatar

Avatar
Boost 5
Employee
Garima_Gakhar
Employee

Likes

44 likes

Total Posts

77 posts

Correct reply

38 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Employee
Garima_Gakhar
Employee

Likes

44 likes

Total Posts

77 posts

Correct reply

38 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
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.