Veridata Comparison

(Doc ID 2321885.1)

Last updated on NOVEMBER 18, 2017

Applies to:

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

Goal

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.

 

Solution

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