It is assumed that:
-
The source host and server are defined.
-
The target hosts and servers are defined.
-
Distribution tables are in the available cache for the source and for the target.
-
Source to target distribution is completed as usual.
In this exercise, each table in the distribution pattern is both a source and a receiving table. You want to distribute data from source table DIVISION1.PAYROLL to receiving table DIVISION2.PAYROLL and from source table DIVISION2.PAYROLL to receiving table DIVISION1.PAYROLL. You create an Enterprise Data Movement Model (EDMM) for distributing data between two source tables in a bi-directional distribution pattern.