Newsletters Welcome, Guest Log In | Register


Join the Community

Exchange

Get full access to our community's expertise and resources.

Register Now >

Currently Being Moderated

Data Warehousing ETL Checklist

0

Created on: Jul 22, 2009 10:52 AM by MichaelStevens - Last Modified:  Jul 22, 2009 10:53 AM by MichaelStevens

ETL – Extract, Transform and Load – is the process by which data from multiple systems is consolidated, typically in a data warehouse, so that executives can obtain a comprehensive picture of business functions, e.g. the relationships between marketing campaigns, sales, production and distribution. It has been estimated that in any data integration project, ETL will consume 60 to 70 percent of the time and resources.

The process is complicated and has been the subject of numerous books. Anyone undertaking an ETL project for the first time will have to do some serious research. Here is a high-level checklist of the important topics.

The attached Zip file includes:

• Intro Page.doc

• Cover Sheet and Terms.pdf

• Data Warehousing ETL Checklist.doc

Related Knowledge Network Content

Average User Rating
(0 ratings)




Add a comment Leave some feedback about this document.

There are no comments on this document

Windows 7 Upgrade Project Kit

Moving to Windows 7? The Windows 7 Upgrade Project Kit is the ideal support tool for managing all phases of an organizational upgrade to Windows 7. The tools and templates in this kit will help you develop a strategy and map out the implementation tactics which link your Windows 7 deployment to your company's bottom line.

Learn more >

ITIL V3 Foundation - Complete Certification Kit

Enhance your IT career by getting your ITIL Foundation Certificate. It's fast and easy with this complete resource. The 186-page eBook and companion online training course is guaranteed to help you pass the ITIL exam.

Learn more >

Rethinking Storage Virtualization with the HP SAN Virtualization Services Platform

This white paper examines how a properly implemented virtualized storage infrastructure can enable you to meet business challenges while satisfying your data growth requirements — without injecting complexity into your infrastructure.

Oracle Database 11g for Data Warehousing and Business Intelligence

Want to learn how to get more from your data warehousing investment? This white paper discusses the key features and technologies by which this innovative business intelligence and data warehouse system can integrate information, perform fast queries, and scale to very large data volumes, all with best-of-breed data analytics.