Data warehouses can run smoothly and fit the needs of both business managers and the information technology department if data warehousing professionals take care in selecting the right extract, transform and load (ETL) tools. "Don’t get involved with a stove pipe system," Pieter Mimno, an independent consultant, told conference attendees Nov. 6 at TDWI World Conference – Fall 2001 in Orlando, FL.

Effective ETL processes represent the number one success factor for a data warehouse project and can absorb up to 70 percent of the time spent on a typical warehousing project. ETL tools promise quick results, improved manageability and meta data integration with other common design and implementation tools. However, due to the potentially huge amounts of money involved in a tool decision, choosing the correct ETL tool for the project can present a challenge.

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