W5 asig ETL and Data Warehousing Essay Example | Topics and Well Written Essays - 500 words

W5 asig ETL and Data Warehousing - Essay ExampleAccordingly, the need for locating an let ETL provider was the aim of increasing revenue by reducing fraudulent ticket processing. That meant finding a way to quickly and efficiently query their data warehouse. That meant Sybase (Sybase, 2014, p. 1). In addition, the data warehouse system of American Airlines through Sybase enabled the provision of the following results detect fraudulent ticket-processing, track ticket sales properly and view proper revenue is flowing into the company (Sybase, 2014, p. 1).QSAM Sequential flat files ISAM VSAM KSDS, RSDS, ESDS - support GROUPS, multi-level arrays, REDEFINES, and all PICTURE clauses. DB2, Adabas, illusionist OCI ( For releases 7 and 8 ) , Sybase Open Client , Informix CLI , OLE/DB for Microsoft SQL Server 7, ODBC.Generic ODBC, HP NeoView, IBM DB2/UDB, Informix IDS, Microsoft SQL Server, mySQL, Netezza, Teradata, Oracle, Sybase adaptative Server Enterprise (ASE), Sybase IQ. Native bulk loading supported for all major databases.Provides PowerConnect modules for connecting to PeopleSoft, Siebel and SAP R/3. Informatica is coming out with an Open PowerConnect API for rest of the ERP systems. So customers can write interfaces using this module.DataStage XE provides affluent integration with leading enterprise applications including SAP, Siebel, and PeopleSoft. The DataStage Extract PACKs for SAP R/3, Siebel and PeopleSoft, and the DataStage Load PACK for SAP BW enable warehouse developers to integrate this data with the organizations other data sources.DI Automatically generates an appropriate interface calls to entranceway the data into the source systems. For most ERP applications DI generates optimized SQL for the specific target database systems (Oracle, DB2, SQL Server, and Informix)Enhances performance and reduces I/O with its built-in kind and aggregation capabilities. The Sort and Aggregation stages of DataStage work directly on rows as they pass through th e engine rather