Data Acquisition - ETL White Papers
A Flexible Data Integration Architecture Using WebSphere DataStage and WebSphere Federation Server: Introducing the T-ETL Architecture
Overview WebSphere DataStage is an inherently flexible data consolidation tool that can natively support ETL, ELT, and TEL topologies. This paper shows how the combination of WebSphere DataStage and WebSphere Federation Server can extend the alphabet soup by effectively supporting Transform-Extract-Transform-Load (T-ETL) data consolidation topologies. Within a T-ETL topology, WebSphere DataStage and WebSphere Federation Server complement each other in such a manner that significant performance benefits and CPU savings can be achieved relative to using WebSphere DataStage alone. In this scenario, WebSphere Federation Server is able to perform processing close to the input sources so that less data is presented to the extraction stage, and less transformation needs to be done by WebSphere DataStage.
| Publisher | IBM | File Format | HTML |
|---|---|---|---|
| Date Published | March 2007 | ||
| Format | White Papers | ||
| Topics | |||
-
Did you find this white paper useful?
White Paper RSSBase SAS Vs. SAS Data Integration Studio: Understanding ETL and the SAS Tools Used to Support It
DownloadNow all grown up and ready to take on the world, SAS software's ability to get at just about any data source, massage, cajole, beat, cleanse and transform information and...
ETPL - Extract, Transform, Predict and Load
Implementing an "Extract, Transform, Predict and Load" process can generate a huge variety of new opportunities. Since predictive analytics automates the process of finding new values or associations within in...
Advanced ETL With Pentaho Data Integration
The recent quote in the industry press about the great potential of Pentaho Data Integration (formerly named Kettle) drew a lot of questions (and a few critical comments) from many...
Understanding the System Architecture of SAS/ETL and SAS/EBI Server for Federal Enterprise Architecture Requirements
This paper describes some of the key points learned through: many conversations with SAS Institute, and persistence to understand how the SAS Enterprise Business Intelligence Server and the Extraction, Transformation,...
A Pragmatic Programmers Introduction to Data Integration Studio
ETL is the process of moving data from a source system (such as operational systems or a table in a database) into a structure that supports analytics and reporting (target)....
