Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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.