OAG receives data from the vast majority of airlines operating flights worldwide. This data, received in a variety of formats and with varying levels of consistency, needs to be cleaned, validated, stored, and redistributed to OAG's clients. The data was previously stored on a set of mainframes that ran custom-developed programs. OAG recently launched a migration program, to transfer the applications to DB2 RDBMS on IBM/AIX platforms. As part of its migration strategy, OAG decided to abandon proprietary technologies and custom scripts and to use an open system with an industry-standard RDBMS. The unique approach of Oracle Data Integrator [formerly called Sunopsis] is that it does not use a proprietary engine but rather relies on RDBMS engines to transform and process data.
Did you find this white paper useful?
24 out of 50 users found this white paper useful
Related white papers
SAP Business Information Warehouse Facilitates Quick, Accurate Reporting
In a highly competitive, international financial market, managers must quickly assess opportunities and risks across all levels of the bank. To do so, they require ever-faster access to more accurate...
A Strategic Approach to Protecting SCADA and Process Control Systems
Process Control Systems (PCS) refer to the overall set of systems that remotely monitor and measure remote sensors from a centralized location. These sensors also typically possess some type of...
Reference Data Management Now!
This webcast helps one learn about the best practices for the full cycle of reference data management - from data acquisition through "golden source" data distribution. The webcast helps one...
Ensuring You Have the Proper Resources for Your SAS9 Applications
This paper contains information to help readers manage and monitor their computer environment to ensure that they have adequate resources to support their SAS9 applications. The paper briefly describes the...
A Flexible Data Integration Architecture Using WebSphere DataStage and WebSphere Federation Server: Introducing the T-ETL Architecture
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...
SQL Server 2005 Enhances Performance of Data Warehouse for Microsoft IT Tax Group
Microsoft Corporation, the world's largest software development company, has annual revenues exceeding U.S.$34 billion and operations in 89 countries. As with other global companies, Microsoft has lots of taxes to...
Three Terabyte Data Warehouse Set for Growth With SQL Server 2005
CROSSMARK helps the Consumer Packaged Goods (CPG) industry refine marketing efforts by gathering vast amounts of Point-Of-Sale (POS) information into a data warehouse. As the company prepared to expand its...
