Which statement best describes the record Image that an…

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *