Show TOC

Object documentationModeling Realignment

 

Look-up or distribution tables are the assignment tables that are used to ensure that every site receives the data that is relevant to it in its local dataset. The look-up tables are maintained not directly, but rather through various actions in the administration console.

 

The relationship between replication objects and the sites that are responsible for them is created in the look-up tables. For each relationship, the site ID and the corresponding replication key or distribution key (system key of the highest segment of the replication object) are maintained in these tables.

Example

Example of the structuring of a look-up table:

Distribution Key

Site ID

123

A001

123

A002

234

A001

234

A003

345

A003

456

A001

Site A001 receives data using distribution keys 123, 234, and 456.