My Oracle Support Banner

Blank to Null Conversion (Doc ID 2330478.1)

Last updated on FEBRUARY 03, 2019

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

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
Goal
Solution
References


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