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) >=