Veridata Comparison (Doc ID 2321885.1)

Last updated on FEBRUARY 28, 2020

Applies to:

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

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