Map and distribute data scenario - Connect_CDC - connect_cdc_mimix_share - Latest

The scenario described in this section is a mapping and distribution of data from a single source table to three target tables on three machines. A software company keeps a database of customer information, tracking customer and software information in which ITEM_ID and SALES_DATE are columns. The supplier wants to identify customers who have purchased a particular item recently so that these customers can be targeted with special marketing about an upgrade. One division will be responsible for this marketing. Customers who purchased the item earlier in the year or in a previous year will receive different marketing information from different divisions.      

Finally, some of the target tables are updated by users at those sites, so occasional conflicts between user updates and replicated updates are assumed to be likely.

The scenario assumes:

• The source host and server (Oracle UNIX) are defined.

• The target hosts and servers (Oracle UNIX, Oracle) are defined.

• Distribution tables are in the available cache for the source and for the targets.

The principal topics in this section are:

• Define the distribution and the request

• Define the conditional expression

• Define additional conditions

• Restrictions

• Detect collisions

• Complete the model and run the request

• Compare the contents of the source and target tables