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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Adobe v7 merge records function

Avatar

Level 2

When two records are merged in adobe using the update activity, any transaction history (broadlog, tracking, etc) that was tied/associated to losing record, will all that get tied to the winning record id? or not.

1 Accepted Solution

Avatar

Correct answer by
Level 2

Hi Tasheen,

If you are replacing losing recipient with winning recipient then for associating transaction history tables you have to update the primary key of winning recipient with foreign key of losing recipient in transaction history tables.

Regards,

S

View solution in original post

4 Replies

Avatar

Correct answer by
Level 2

Hi Tasheen,

If you are replacing losing recipient with winning recipient then for associating transaction history tables you have to update the primary key of winning recipient with foreign key of losing recipient in transaction history tables.

Regards,

S

Avatar

Level 2

Thanks Sourabh, thats what I thought. Appreciate the help!

Avatar

Level 3

Hi, so just to make sure I understand, the merging of the two records does NOT really merge them unless you "update the primary key of winning recipient with foreign key of losing recipient in transaction history tables."  So, unless that is done, you are not truly merging the recipients, correct? Is there an easy way to update the foreign key?

Thanks,

Eugene

Avatar

Level 4

In this case, wont the logs of losing recipient which had a different primary key get deleted/removed?