Does OGG Replicat for Teradata perform a ROWNUM=1 check ? (Doc ID 2241223.1)

Last updated on APRIL 18, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.1.0 and later
Information in this document applies to any platform.

Symptoms

 In OGG for Teradata, the replicat is not performing ROWNUM=1 check

Changes

In OGG for Teradata, the replicat is not performing ROWNUM=1 check

Unconditional Supplemental logging is enabled and KEYCOLS include all the columns in the source tables to perform the test.

When target is Oracle, it is seen that replicat is constructing UPDATE SQL with the condition ROWNUM=1 so that only row is touched at a time in case of duplicate records.

But when target is Teradata, the replicat is not performing ROWNUM=1 check.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms