Responsys Supplemental Table PK and DEK
Hi community,
We are facing a problem concerning the behaviour of the public key of a supplemental table. More precisely:
1. We have a supplemental table with 4 fields: EMAIL_ADDRESS_, ADHOC_PREF_A, ADHOC_PREF_B and ADHOC_SOURCE. The PK is the combination of the fields "EMAIL_ADDRESS_" and "ADHOC_SOURCE" and the DEK is the field "EMAIL_ADDRESS_".
2. We have two forms "PREF_FORM_X" and "PREF_FORM_Y" to populate the supplemental table. In the first form we set ADHOC_SOURCE=BF_2019 (as a hidden field) and in the second form we set ADHOC_SOURCE=BF_2020 (as a hidden field). Both forms are set to update the record in the Profile List if a matching record is found.
0