Instead of replicating source table changes to a target table, journal mapping inserts a series of entries in the target table, one row for each insert, update, or delete at the source.
The transactions are sent to the journal (target table) as SQL INSERTs.
|
Transaction |
What It Includes |
|---|---|
|
Source INSERTs |
|
|
Source UPDATEs |
|
|
Source DELETEs |
|
The following information is sent to the target.
|
Row Manipulation Type |
Before values |
Sends to target |
|---|---|---|
|
Insert |
NULL |
|
|
Update |
update column only |
|
|
Delete |
NULL |
|