Work of this nature is tedious and exceptionally detail oriented. It requires lots of manual data inspection, test runs, debugging, and forward thinking on the part of the developer working on the project. When all is said and done, the results are almost guaranteed to be worth the effort.
Working with clean data makes everything easier. Just don't underestimate how challenging the journey to clean data may be.
Sign up for CIO Asia eNewsletters.