Ive been tasked with looking into testing/ validating data conversion. Specifically, the correctness of converting data. Formats I know of so far is the data source is an AS400. The data destination is Oracle. We want to know if there is a type of reporting, and/or side-by-side file comparison tool(s) that perform this type of 'testing'.
Any help is appreciated.
The best method for a data conversion test is to go back again from Oracle to a new table in the AS400. Then, query the original and new AS400 tables and note any differences.
I am not sure if you have a linear difference tool such as windiff, but you could also consider running the conversion query on both locations, and do a difference report on the results stored in two different files.
Software Test Engineer
If builders built buildings the way programmers wrote programs, then the first woodpecker that came along would destroy civilization.