Blank to Null Conversion
(Doc ID 2330478.1)
Last updated on FEBRUARY 19, 2019
Applies to:Oracle GoldenGate Veridata - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
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.
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