Modeling 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 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.