Oracle Global Human Resources Cloud Implementation Specialist — Question 28

You want to generate an extract file or trail in a non-GoldenGate canonical format like those used in the Initial Load file-todatabase utility. How should you configure GoldenGate in order to accomplish this?

Answer options

• A. Configure Replicat with the FORMATASCII SQLLOADER OPTION.
• B. Configure Extract with the FORMATSQL SQLLOADER OPTION.
• C. Configure Extract with the FORMATASCII SQLLOADER OPTION.
• D. Configure Replicat with the FORMATXML OPTION.

Correct answer: C

Explanation

The correct answer is C because using FORMATASCII SQLLOADER OPTION in the Extract configuration allows GoldenGate to create an extract file in the desired non-canonical format. Option A is incorrect because Replicat is not responsible for generating the extract file, while options B and D do not use the correct formatting needed for this task.