DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
shamshad



Group memberships:
Premium Members

Joined: 25 Aug 2004
Posts: 147
Location: Detroit,MI
Points: 1383

Post Posted: Tue Aug 08, 2017 1:43 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: DataStage and Informatica
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



Joined: 09 Apr 2015
Posts: 63
Location: France - Nantes
Points: 412

Post Posted: Tue Aug 08, 2017 3:53 am Reply with quote    Back to top    

Maybe you could take a look at John's posts on that topic :

_________________
BI Consultant
DSXConsult
Rate this response:  
JRodriguez



Group memberships:
Premium Members

Joined: 19 Nov 2005
Posts: 426
Location: New York City
Points: 4771

Post Posted: Tue Aug 08, 2017 11:30 am Reply with quote    Back to top    

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
Rate this response:  
PaulVL



Group memberships:
Premium Members

Joined: 17 Dec 2010
Posts: 1310

Points: 8608

Post Posted: Tue Aug 08, 2017 3:24 pm Reply with quote    Back to top    

what did you think of it?
Rate this response:  
UCDI



Group memberships:
Premium Members

Joined: 21 Mar 2016
Posts: 383

Points: 3950

Post Posted: Wed Aug 09, 2017 10:39 am Reply with quote    Back to top    

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.
Rate this response:  
cppwiz
Participant



Joined: 04 Sep 2007
Posts: 135

Points: 1273

Post Posted: Tue Nov 21, 2017 1:50 pm Reply with quote    Back to top    

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.
Rate this response:  
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours