GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Goldengate Ignoredeletes based on date

Hi All,

Our GG version is 12.2(extract)/11g(replicat) and we have a requirement where deletes on the source table older than 7 years shouldn't be replicated to target table. On looking at it there is a ignoredeletes parameter which can be used .But how could we specify to ignoredeletes only when it meets the criteria the deletion of data is older than 7 years and need to capture deletes and replicate it when it is less than 7 years..There is below parameter in Oracle support but not sure whether its right one.

Replicat:

MAP {source table}, TARGET {target table},

FILTER (@COMPUTE (@DATE("JUL", "YYYY-MM-DD", creation_time) >=

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center