Automated Tool for ETL Testing/Validation

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
shamshad
Premium Member
Premium Member
Posts: 147
Joined: Wed Aug 25, 2004 1:39 pm
Location: Detroit,MI

Automated Tool for ETL Testing/Validation

Post 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.
Datawarehouse Consultant
Thomas.B
Participant
Posts: 63
Joined: Thu Apr 09, 2015 6:40 am
Location: France - Nantes

Post by Thomas.B »

Maybe you could take a look at John's posts on that topic :
BI Consultant
DSXConsult
JRodriguez
Premium Member
Premium Member
Posts: 425
Joined: Sat Nov 19, 2005 9:26 am
Location: New York City
Contact:

Post by JRodriguez »

Recently I was evaluating the iCEDQ application for same purpose

https:/icedq.com
Julio Rodriguez
ETL Developer by choice

"Sure we have lots of reasons for being rude - But no excuses
PaulVL
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post by PaulVL »

what did you think of it?
UCDI
Premium Member
Premium Member
Posts: 383
Joined: Mon Mar 21, 2016 2:00 pm

Post 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.
cppwiz
Participant
Posts: 135
Joined: Tue Sep 04, 2007 11:27 am

Post 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.
Post Reply