Q:  

I am interested in finding benchmark tests that have compared ETL tools. For example, has anyone tested throughput on 40 million records with the same transformations running an engine-based tool such as Informatica and then running them through a code based tool like ETI?

A:  

Chuck Kelley's Answer: There are none that I know of because it would be rather hard to do and every (losing) vendor would say that you did not use their product correctly. I always ask the vendors to show me how they would solve a particular problem and explain what happens behind the scenes. Then, based on what they tell me, I decide whether they truly understand using large data sets like the 40 million rows you indicated.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access