The corporate rollup model has distributed primary fragments and a single, centralized consolidated replicate table. The table at each primary site contains only the data that is primary at that site. No data is replicated to these sites. The corporate rollup table is a “roll-up” of the data at the primary sites.
Figure 1-5 illustrates the flow of data for a corporate rollup application model:
Figure 1-5: Distributed primary fragments with corporate rollup
The corporate rollup model requires distinct replication definitions at each primary site. The site where the data is consolidated subscribes to the replication definition at each primary site.
To create a corporate rollup application from distributed primary fragments:
Activate a replication agent at each primary site. However, you do not need to activate a replication agent at the central site, since data is not replicated from that site.
Create tables in each primary database and in the database at the central site.
Allow for replication on tables at each remote database where primary data is stored.
Create replication definitions for tables at each remote site where primary data is stored.
At the headquarters site, where the data is to be consolidated, create subscriptions for the replication definitions at the remote sites.
