Portals eNewsletters Web Seminars dataWarehouse.com DM Review Magazine
DM Review | Covering Business Intelligence, Integration & Analytics
   Covering Business Intelligence, Integration & Analytics Advanced Search
advertisement

RESOURCE PORTALS
View all Portals

WEB SEMINARS
Scheduled Events
Archived Events

RESEARCH VAULT
White Paper Library
Research Papers

CAREERZONE
View Job Listings
Post a job

Advertisement

INFORMATION CENTER
DM Review Home
Newsletters
Current Magazine Issue
Magazine Archives
Online Columnists
Ask the Experts
Industry News
Search DM Review

GENERAL RESOURCES
Bookstore
Buyer's Guide
Glossary
Industry Events Calendar
Monthly Product Guides
Software Demo Lab
Vendor Listings

DM REVIEW
About Us
Press Releases
Awards
Advertising/Media Kit
Reprints
Magazine Subscriptions
Editorial Calendar
Contact Us
Customer Service

ETL Portal

This portal sponsored by

ETL - extract, transform and load - is the set of processes by which data is extracted from numerous databases, applications and systems, transformed as appropriate, and loaded into target systems - including, but not limited to, data warehouses, data marts, analytical applications, etc.

More than half of all development work for data warehousing projects is typically dedicated to the design and implementation of ETL processes. Poorly designed ETL processes are costly to maintain, change and update, so it is critical it is to make the right choices in terms of the right technology and tools that will be used for developing and maintaining the ETL processes.

Some of the numerous technological approaches and solutions available on the market include:

  • Traditional engine-based ETL products
  • RDBMS proprietary solutions
  • Third-generation E-LT solutions, based on a code-generation approach that uses the power of the RDBMS engines to perform the data transformations

Brought to you by Sunopsis and DM Review, this ETL resource portal is an excellent channel for all users searching for specialized information and looking to decide on a technology, or just wanting to keep abreast of the latest developments. Read related editorial and research white paper provided by DM Review and Sunopsis, the leading provider of cost-effective E-LT and Integration solutions. We'll be adding new material as soon as it is published so bookmark this site and visit often!

RELATED ARTICLESETL RELATED CONTENT

Deming, Data Quality and ETL, Part 2 :
Point 5 - Constant Improvement
By Fon Silvers
This approach requires a great deal of effort; however, the benefit of including a data quality process in the creation of an ETL application is a data warehouse that can be trusted.

Intelligent Solutions
By Lisa Loftis
Don't Blink - You Might Lose Your Vendor, Part 1

Problem Solved
By James Masuoka
Mr. Outsourcer? The Subsequent Backlash is Here to See You.

65 more related content available. Click Here!


WHITE PAPERSETL WHITE PAPERS

Third Generation ETL: Delivering the Best Performance
Available for download in: PDF format

Is SQL Becoming the Industry Standard Language for Data Integration?
Available for download in: PDF format

Sunopsis Integration Suite: An Evaluation by Bloor Research
Available for download in: PDF format

The Complexity Advantage: Solving the Requirements of Complex Data Transformation in Business Integration
Available for download in: PDF format

14 more whitepaper(s) available on this topic. Click Here!

Looking for other white papers? Visit the complete White Paper Library.


BOOKSETL BOOKS


Managing Gigabytes: Compressing and Indexing Documents and Images
By Ian H. Witten, Alistair Moffat, Timothy C. Bell

This title is a textbook-style exposition on the topic, with its information organized very clearly into topics such as compression, indexing, and so forth. In addition to diagrams and example text transformations, the authors use "pseudo-code" to present algorithms in a language-independent manner wherever possible. They also supplement the reading with mg--their own implementation of the techniques. The mg C language source code is freely available on the Web.

1 more book(s) available on this topic. Click Here!


MORE RESOURCESMORE ETL RESOURCES

Read product reviews on ETL products.
Check out ETL software demos.
Read ETL questions and answers in Ask the Experts.

Interested in receiving an update of DMReview.com editorial on ETL? Subscribe to our Content Alert e-mail. You'll receive a topic-specific e-mail focused on industry topics. Subscribe Here!



Portal Menu
Welcome
Articles & Columns
White Papers
Books
Newsletters
View all Portals
Advertisement
advertisement
Site Map Terms of Use Privacy Policy
SourceMedia (c) 2006 DM Review and SourceMedia, Inc. All rights reserved.
SourceMedia is an Investcorp company.
Use, duplication, or sale of this service, or data contained herein, is strictly prohibited.