Which statement best describes the record Image that an Extract process stores in the GoldenGate trail by default?

Which statement best describes the record Image that an Extract process stores in the
GoldenGate trail by default?

A.
The new value for updated fields; the primary key for deleted rows; the after-Image for inserts

B.
An image of the contents of the record after the insert, update or delete operation

C.
An after image for inserts and a before image for updates and deletes

D.
An after image for Inserts and updates and a before image for deletes

Explanation:
An after image for inserts and updates and a before image for deletes.According to
these guides:1. http://docs.oracle.com/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf, page
190,GETUPDATEAFTERS/IGNOREUPDATEBEFORES are the DEFAULT values of the
parameters which control whether or not the after/before images of updated records are included
in the records processed by GoldenGate.2. Oracle GG Fundamentals Student Guide, Version
10.4, page 113, Extract Parameters, Extract Parameter Defaults slide… Only after-image of
update

Show Hint

← Previous question

Next question →

Leave a Reply 6

franciscotmjr

The correct answer is A.

S De

Ans should be C

John Rambo

Ans is correct: D

ASCII version of trail file:
B,2015-09-25:07:03:40.000000,1443182620,16221,
I,A,xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx –I=insert, A=after image
V,A,xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx –V=compressed update, A=after image

B,2015-09-25:07:04:16.000000,1443182656,16221,
D,B,xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx –D=delte, B=before imagea

Ashish

Answer should be A,
All Extract parameters assume a default value:
 Capture all insert, update and delete operations
 Committed data only
 Full image for inserts
 Only primary key and changed columns for updates
 Only primary key for deletes
 Only after-image of update

Oratech

I think D is correct.
Why not A ?
Because he said “The new value for updated fields;”, but for updates, primary key also is captured (primary key + changed columns).

rsv1999

D is correct.

When the operation type is Insert or Update, the image contains the contents of the record after the operation (the after image). When the operation type is Delete, the image contains the contents of the record before the operation (the before image).