Unanswered: Flat file loading in sybase IQ & load verification
I have a Java load code which will load the flat file received from a MF system to sybase IQ database. The data volume is very huge and its loaded into multiple tables (around 35). Now I need to verify the data loaded correctly or not.
Apart from verifying log, is there any other best method or algorithm thru which I can verify the data loading?
What is the best optimal way to verify the data loaded in sybase IQ?
I thought of exporting the data back to flat file and do a windiff. Thats not a nice idea. Any other better suggestion would be very nice.
It would be of great help to me.Thanks a lot in advance.