Error OGG-01157 Using Where Clause With Dates and OGG-00375 with @NULL Clause With GoldenGate for Teradata (Doc ID 1564687.1)

Last updated on JANUARY 25, 2017

Applies to:

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

Symptoms

You are using GoldenGate 11.1.1.0.27 to replicate data to Teradata and want to only replicat those records where abs_date column will consists records less than 2 years only from current date(i.e. now year is 2013 and so i want to fetch the records only till 2011).

Previously this syntax worked -

 

 

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