Add a Dedup Table to control how data in custom tables is handled during the Combine and Merge Duplicate Records process.
To add a Dedup Table, use the following steps:
Field Name | Required | Description |
---|---|---|
file group | Required | Select the file group in which the table will be stored. |
table name | Required | Select the table name. |
customer | Required | Select the customer key name. |
update order | Optional | Enter the order in which this table should be processed. |
sql before merge | Optional | Enter any SQL commands or stored procedures to run immediately before the combine/merge process. |
sql after merge | Optional | Enter any SQL commands or stored procedures to run immediately after the combine/merge process. |