Advertisement
Promo

Databases Toolkit

Download now

Managing ETL Processes

PublisherAssociation for Computing Machinery
Format270.0KB PDFDate added30 Aug 2008
Topics Data Acquisition - ETL, Business Intelligence - Data Warehousing
Downloads20

ETL tools allow the definition of sometimes complex processes to extract, transform, and load heterogeneous data into a data warehouse or to perform other data migration tasks. In larger organizations many ETL processes of different data integration projects are accumulated. Such processes can encompass common sub-processes, shared data sources and targets, and same or similar operations. However, there is no common method or approach to systematically manage such ETL processes. The paper proposes the high-level management of such processes as a generic approach to enable their flexible re-use, optimization, and rapid development. To this end the paper introduces a set of basic operators on ETL processes, such as merge or invert, and motivate their use in several scenarios.

Download now

Did you find this white paper useful?
3 out of 6 users found this white paper useful


  • Trackback
  • Clip Link

Related white papers

Customer Centricity, Master Data and the "360-Degree View"

When reviewing the popular literature on customer data integration and master data management, a frequently recurring business driver is the ability to establish a "360-degree view of the customer." This...


Gaining Perspective on Performance: Best Practices for an Effective 360-Degree Feedback Program

When planned in advance and run strategically, a 360-degree feedback program can offer serious business value. Feedback from multiple raters provides useful data on your employees, their performance, and their...


Predictive Analytics for the Claim Handling Process

Predictive Analytics for the Claim Handling Process: Understanding the Analytics Behind Predictive Claims This 12-page technical brief serves as a guide for understanding how Predictive Claims' predictive modeling capabilities can...


Premier Research Group Limited Supports Clinical Trials With Consolidated, Less Costly IT System

Premier Research Group Limited wanted to leverage technology to be more responsive to clients, ultimately helping clients improve their clinical trials and increasing client satisfaction and consolidate numerous geographically-dispersed clinical...


Windows 7 Adoption Survey: A Survey of Technology Professionals

This Dimensional Research report is based on a survey of 1,142 IT professionals. The goal of the survey was to gather data about current plans and attitudes within corporate IT...


Incorporating Site-Level Knowledge to Extract Structured Data From Web Forums

Web forums have become an important data resource for many web applications, but extracting structured data from unstructured web forum pages is still a challenging task due to both complex...


Visualizing Irish Banter

Discussion forums could benefit from an exploratory search capability. The large quantity of information on discussion forums can present an opportunity for helping a user through visualization. Self organizing maps...


Broadband Deals? Powered by Top 10 Broadband

150+ broadband packages

Compare 30+ mobile broadband deals

Mobile Broadband »
White Paper

Featured White Paper

Technical Description: IBMXIV Storage System

The IBMXIV® Storage System offers a new level of high-end disk system performance and reliability. It is a core component of theIBMInformation Infrastructure which helps clients address their needs for availability, security, compliance and retention of information. The XIVsystem provides consistency under all conditions, immunity to hotspots, ...

Download Now

Other White Papers

Best Practices for Translating Customer Satisfaction into Revenue

Today's support organisations are focused on two top-level metrics: financial results and customer...

Data Quality Considerations for a Master Data Management Structure

Companies acquiring companies. Human Resources sharing information with Finance. Businesses...

See All White Papers


Skip Sub Navigation Links to CNET Brand Links

Help

Become part of the ZDNet community.

Newsletters