Valid For

Extract and Replicat

Description

Use the GETUPDATEAFTERS and IGNOREUPDATEAFTERS parameters to control whether or not the after images of columns in UPDATE operations are included in the records processed by Oracle GoldenGate. After images contain the results of the UPDATE.

These parameters are table-specific. One parameter remains in effect for all subsequent TABLE or MAP statements, until the other parameter is encountered.

Because you can selectively enable or disable these parameters between MAP statements, you can enable or disable them for different threads of a coordinated Replicat. Specify the GETUPDATEAFTERS threads in one set of MAP statements, and specify the IGNOREUPDATEAFTERS threads in a different set of MAP statements.

Default

GETUPDATEAFTERS

Syntax

GETUPDATEAFTERS | IGNOREUPDATEAFTERS

Example

This example shows how you can apply GETUPDATEAFTERS and IGNOREUPDATEAFTERS selectively to different MAP statements, each of which represents a different thread of a coordinated Replicat.

GETUPDATEAFTERS
MAP sales.cust, TARGET sales.cust, THREAD (1);
MAP sales.ord, TARGET sales.ord, THREAD (2);
IGNOREUPDATEAFTERS
MAP sales.loc, TARGET sales.loc, THREAD (3);