I encountered problem finding tool or software for data validation or ETL testing. I found only 2 solutions: QuerySurge and Informatica.

Advise, suggest any other tool or share experience.

Im sure, given post will further contribute to those who will try to establish validation process like me.

  • 1
    What are you looking for in a tool that isn't met with the two tools you've found already? – jruberto Jan 18 '14 at 16:37
  • Everything is ok with those two, but I want to choose more than out of two tools. Are those tools are the only option? – user6731 Jan 20 '14 at 3:05

Informatica DVO only works if you have PowerCenter as your ETL tool. QuerySurge works with any ETL tool. Try the free download.

  • 2
    Could you give a bit more information about your experience with these tools? It would help the original poster to know more about both. – Kate Paulk Jan 21 '14 at 12:03

If the goal includes test data sets you need to vet ETL operations (across DBs and packages), I would be looking at IRI RowGen. It uses the CoSort data manipulation language, which also supports data validation and transformation within test data generations. Compare the outputs of those (consolidated) job scripts to verify your mappings produced the same results against that safe, referentially correct data.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.