 |
|
Oracle Tips by Burleson |
Oracle Streams
Chapter 2 -
Streams
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
destination database.
-
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:
Oracle Streams
High Speed Replication and Data
Sharing
ISBN 0-9745993-5-2
by Madhu Tumma
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
