Figure 7-4 illustrates the typical message flow during subscription dematerialization.
Figure 7-4: Subscription dematerialization
During subscription dematerialization:
The replicate Replication Server selects data from the replicate data server to construct the dematerialization queue. The replicate data server uses its sort order to select the rows.
The replicate Replication Server uses its sort order to throw out rows belonging to other subscriptions.
The replicate Replication Server deletes the remaining rows from the replicate database.