Almost all of our customers who are migration from Netezza to IIAS need us to provide a report certifying the quality of data. db_checksum is the obvious choice, however the tool has limitations.
1. Currently the tool provide one check sum value per table. It does not give check sum value per column. If there is a difference in check sum value between NZ and Sailfish, its very difficult which column is the culprit. We need to be able to give checksum value per column.
2. The tool is extremely slow, especially larger tables. We should explore how to speed up the performance.
|Who would benefit from this IDEA?||All Netezza to IIAS migration customers.|
How should it work?
Ideally it should work the same was as nz_checksum.
|Priority Justification||Most of the NZ to IIAS customers would need this tool|
|Customer Name||Toyota Financial Services|
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "firstname.lastname@example.org" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions