FREE DM Review Site Registration!
Sign-up today and access DM Review on the Web!

Your FREE registration entitles you to:

FREE email newsletters

FREE access to all DM Review content

FREE access to web seminars, resource portals, our white paper library and more!

   
BI Review content and features are now in DMReview.com!

One brand, one Web site! DM Review is now the home of all the content you're used to at BIReview.com and much more. If you are registered at BIReview.com, you're already registered at DM Review. If not, take just a moment to sign up for all the free services we have for you at the new DMReview.com.

ETL Channel

Channel Sponsored by
Syncsort

Extract, transform and load (ETL) are primary steps in reporting and in the creation and maintenance of a data warehouse. ETL is accomplished through the use of tools offered by different vendors that manage all three steps: data is extracted selectively from a chosen database, transformed into formats that support queries, and loaded into tables in the data warehouse or other target database. The high volumes of data processed via ETL make performance, time deadlines and cost primary issues and challenges for database administrators.

Articles

Murphy’s Laws of Data Warehousing: What Goes Bump in the Night?

Murphy’s Law tells us that whatever can go wrong will go wrong. This axiom applies to all aspects of life, including data warehousing.

The Value of an IT Automation Platform

Until recently, implementing automation to achieve the benefits of automated IT operational processes has proven costly and difficult to maintain.

Columns

Trial-and-Error Method of ETL

Ensuring Quality Data

Data Warehouse Design in the Real World, Part 1

Six Degrees of Separation: Connecting the Dots Between Business and Technology Using ETL

Ask the Experts

With respect to ETL integration from one system to the other, what steps needs to be considered when planning an aquisition or merger?

What are your views on the advantages and/or disadvantages ETL tools and data modeling versus code?

How can I enhance the productivity of my fact table load?

How important is data reconciliation for an ETL application?

Please give some suggestions to prepare an estimation effort for our ETL process.

White Papers

Sunopsis Integration Suite: An Evaluation by Bloor Research

By Bloor Research

Third Generation ETL: Delivering the Best Performance

By Yves De Montcheuil and Chris Dupupet

Advanced ETL with Pentaho Data Integration

By By Christopher Lavigne

Evaluating Real-Time Data Integration Solutions

To V or Not To V: Business Intelligence Gets Virtual

Books

Building and Managing the Meta Data Repository: A Full Life-Cycle Guide

By David Marco

Managing Gigabytes: Compressing and Indexing Documents and Images

By Ian H. Witten, Alistair Moffat, Timothy C. Bell




Industry Vendors