0

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.

2
  • 1
    What are you looking for in a tool that isn't met with the two tools you've found already?
    – jruberto
    Jan 18, 2014 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, 2014 at 3:05

2 Answers 2

1

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

1
  • 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, 2014 at 12:03
1

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 and acknowledge you have read our privacy policy.

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