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.
Related white papers
Enabling Operational Business Intelligence With Real-Time Data Integration Solutions
As organizations continuously expand through technology along with facing a worldwide competition, it is important to be on top of every aspect of your business and markets served. This is...
Real-Time Business Intelligence and Data Integration as a Strategic and Critical Component
This white paper discusses the strategic role that Data Integration plays in achieving Real-time Business Intelligence, with On-Demand access, integration, delivery and usage of enterprise information.
Business Modeling: A New Paradigm for Designing and Implementing Enterprise Data Warehouses
An enterprise data warehouse provides management with information about what is happening in the business. It must present a single version of the truth from multiple perspectives - and quickly...
Unlocking the Potential of Radio Frequency Identification Technology
This white paper from IBM explains how Radio Frequency Identification (RFID) technology can help companies across diverse industries drive down the costs associated with asset and inventory management. The paper,...
Mining@home: Public Resource Computing for Distributed Data Mining
Several kinds of scientific and commercial applications require the execution of a large number of independent tasks. One highly successful and low cost mechanism for acquiring the necessary compute power...
Ferplast Improves Service and Maintains Competitive Edge With Data Integration
Ferplast SpA a leading supplier of more than 2,000 pet products, wanted to provide management the ability to reorganize information quickly by classifications in the staging area, and obtain reports...
Ethernet Network-Based DAQ and Smart Sensors for the OPERA Long-Baseline Neutrino Experiment
This paper proposes a data acquisition scheme for the OPERA long-baseline neutrino experiment based exclusively on Ethernet. The expected data rate allows the use of an Ethernet capable device close...


