Last updated on NOVEMBER 18, 2017
Applies to:Oracle GoldenGate Veridata - Version 220.127.116.11.1 and later
Information in this document applies to any platform.
Q1:- Is there any provision in veridata to filter the comparison based on string matching on a particular column ?
Q2:- We have specific requirement. Let's consider table C in source database A and destination database B.
Database A has three record in table C "Anshuman","Ayushman","Dheeraj" and we have kept one filter in GG that the data which have string "man" only will replicat. so in destination database B will have only two record"Anshuman" and "Ayushman".
Our requirement is to check/verify that the record with string containing 'man' replicated properly or not . So we can not achieve this only giving the PK or colomn name in comparison. We have to put filter "man" also . Please let us know how can we keep this.
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