Blank to Null Conversion
Last updated on JANUARY 18, 2018
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.
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