We ran into issues at client engagements so we created an automated test tool named QuerySurge. You can find it at
I recently published a book titled, "Testing the Data Warehouse". It's available at Amazon.com and through other similar sources. While planning for and writing the book, I collected many reference materials and would be glad to share them; let me know if interested. The book and other documents answer many of the questions posed in this blog post. www.testingdatawarehouse.com, firstname.lastname@example.org
I have been involved in manual ETL testing for past 3 years using Sql ,data extraction and data comparison .
Could someone pls let me know the usage of teradata tool in ETL testing.