Blank to Null Conversion

(Doc ID 2330478.1)

Last updated on JANUARY 18, 2018

Applies to:

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

Goal

I have migrated the data from DB2 iSeries to Oracle DB. I have converted blanks to NULL using SPACESTONULL function in Goldengate. I'm using Veridata to compare the tables between iSeries DB and Oracle DB. Since I converted spaces to null, all those records are showing as differences. How do I skip null values in comparison?. This means, I don't want veridata show a difference exists if same field is blank in iSeries and null in Oracle.
 

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