I am providing information for a proof of concept (my first time) on an ETL tool for a major data conversion project. Could you tell me the most important issues I should be exploring within the proof of concept?
Sid Adelman’s Answer: There are three major points to consider for an ETL tool. The first is how effective and productive the tool is (for your people) in their ability to extract, transform, cleanse (don’t forget that your data is pretty dirty) and load. Their acceptance and comfort with the tool are critical for its eventual use. The second is the performance of the ETL tool with your hardware, operating system and RDBMS. This is especially important if you have a large database to load. The final point is the capability and usefulness of their meta data function and how well it works with the meta data of the other products you will be using such as your modeling tool and access and analysis tool.
Mike Jennings Answer: Some of the more important issues to consider in your proof of concept are: Does the ETL product
Clay Rehms Answer: Yes there are many for an ETL tool, especially performance.
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
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access