Map and distribute from a single-source table to a single, non-identical target table - 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 topic is a mapping and distribution of data from a single source table to a single, non-identical target table. Some of the column names differ, not all columns are to be mapped, and the data in a few columns are adjusted using replication transformation techniques.    

The scenario instructions mix conceptual and procedural information so this single example may be a source of generalization for related situations.

The scenario assumes:

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

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

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