Map and distribute data scenario - Connect_CDC - connect_cdc_mimix_share - 5 - 5.8

Connect CDC Advanced User Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC Advanced User Guide
Copyright
2023
First publish date
2003
ft:lastEdition
2023-09-27
ft:lastPublication
2023-09-27T18:12:55.651884

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: