Defining a Primary Key
When you create a supplemental table to be used for personalization, you must define a primary key constructed from columns in the table. This allows for more efficient loading and updating of the personalization data from the supplemental table into memory.
To define a primary key:
- Select fields in the Available Fields list and use the right arrow to move them to the Primary Key Fields list. Use the left arrow to remove them from the list.
- Select a field in the list and use the up and down arrows to move it into a different position. Use the double arrows to move a field to the top or bottom of the list.
- Click Next.
Important: You can define up to 4 primary key columns in a supplemental table. All the columns defined as primary key taken together (composite key) need to be unique. For example, in purchase orders, only the Email Address cannot be used to select a single record based on email address, however, you can select a single record based on a combination of two primary key columns, Email Address and Order ID.