Configuring Oracle GoldenGate to Support Tables with a SYSKEY or Clustered Key

If your Replicat configuration includes tables that have a SYSKEY or a clustered key, you must take steps to ensure that the correct row is changed during an UPDATE or DELETE operation. Replicat uses an ODBC driver to connect to a target SQL/MX database. This driver does not allow Replicat to get the values of the SYSKEYs in the target tables, so they cannot be used in the WHERE clause to locate rows for processing. You can handle this condition in either of the following ways:

Topics:

• Method One (Handle Using Your Replicat Configuration)
  
• Method Two (Handle Using Your Extract Configuration)