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.