My Oracle Support Banner

Veridata Comparison (Doc ID 2321885.1)

Last updated on FEBRUARY 28, 2020

Applies to:

Oracle GoldenGate Veridata - Version 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.



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.