You can control the period for which unique IDs are held by changing the frequency at which the "UA Partition Mgmt" SQL Server Agent job runs.
The de-duplication database consists of five partitions. The Universal Adapter writes to each of these in turn, switching from one to the next when the "UA Partition Mgmt" SQL Server Agent job runs. After switching to a new partition, the Universal Adapter truncates the partition before writing any new values to it. Therefore, if you change the frequency at which the job runs, you can control how long the Universal Adapter retains unique IDs. For example, setting the job to run every day means that if an email is processed that is a duplicate of an e‑mail seen within the last five days, it will be detected as a duplicate and not written to the outputs. Specifically, in this example, data from the last four days is kept plus data that has accrued in the current partition since the last partition switch took place.
|
Copyright © 2014 CA.
All rights reserved.
|
|