||Oracle Tips by Burleson
Chapter 2 -
Components and Processes
Rule Based Transformations
During the Apply process, it is also possible
to modify certain attributes of the event and the data being
applied. This is possible by employing the rule-based
transformations. A rule-based transformation can, for example,
modify the data type of a particular column in a table for an event.
Thus, a rule-based transformation is any modification to an event
that results when a rule in a positive set evaluates to TRUE.
Transformation can be configured at various
levels in the Streams flow. They are as follows:
During the enqueue of an event by the Capture
process, the event can be formatted to make it appropriate for the
When the events are propagated to a destination
database queue, filtering can be introduced that will reduce the
network traffic and increase the performance levels.
When the events are dequeued by an
Apply process or messaging clients, events can be modified to make
them compatible with destination database.
The above text is
an excerpt from:
High Speed Replication and Data
by Madhu Tumma
Download your Oracle scripts now:
definitive Oracle Script collection for every Oracle professional DBA