1Z0-447: Oracle GoldenGate 12c Implementation EssentialsDemoRetired

By Oracle · Question Mode

QuestionQ36

Parameters

You need to configure GoldenGate parameter files for conflict resolution and ensure that before values are compared with the current values in the target database to identify update and delete conflicts.

How should this be done?

  • 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
Explanation

The COMPARECOLS option of the Replicat MAP parameter specifies the columns whose before images are included in the Replicat WHERE clause. Those before values are compared with the target database’s current values to detect update and delete conflicts. Oracle GoldenGate conflict detection and resolution documentation

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!