Oracle Global Human Resources Cloud Implementation Specialist — Question 36

You must configure GoldenGate parameter files for conflict resolution and want to be sure that the before values are compared with current values in the target database to detect update and delete conflicts.
How should you accomplish this?

Answer options

• A. Use the COMPCOLS with the GETUPDATEBEFORES option of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat WHERE clause.
• B. Use the COMPARECOLS option of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat WHERE
• C. Use the GETUPDATEBEFORES option of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat WHERE clause.
• D. Use the GETBEFORECOLS option of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the Replicat clause. WHERE

Correct answer: B

Explanation

The correct answer is B, as the COMPARECOLS option is specifically designed to define columns for comparison of before values in the Replicat WHERE clause. Options A and C mention GETUPDATEBEFORES, which is not the right choice for this requirement, while option D references GETBEFORECOLS, which is also incorrect for this scenario.