Page 1 of 1
Automated Tool for ETL Testing/Validation
Posted: Tue Aug 08, 2017 1:43 am
by shamshad
We primarily use DataStage 8.5/11.5 for our data integration needs and soon will also be using Information. Currently all our ETL testing are manual.
I am looking for tools/softwares that can be used to "AUTOMATE ETL TESTING" mainly for Datastage and Informatica.
Any suggestion will be appreciated.
Posted: Tue Aug 08, 2017 3:53 am
by Thomas.B
Maybe you could take a look at John's posts on
that topic :
Posted: Tue Aug 08, 2017 11:30 am
by JRodriguez
Recently I was evaluating the iCEDQ application for same purpose
https:/icedq.com
Posted: Tue Aug 08, 2017 3:24 pm
by PaulVL
what did you think of it?
Posted: Wed Aug 09, 2017 10:39 am
by UCDI
datastage with quality stage can do a LOT of testing and you can automate the tests to run the same way you automate your jobs to run, you can have it send email reports or alerts, and so much more. It can join or compare what is in your source and target. It can put your source and target columns side by side. It can run sql and look at the results.
Posted: Tue Nov 21, 2017 1:50 pm
by cppwiz
For Informatica automated testing, google the Informatica "Data Validation Option" or DVO software. In my experience, this software helped the testing team validate the changes without understanding the code.