A Comparative Study of ETL Tools
In many organizations valuable data is wasted because it lies around in different formats and in various r esources. Data warehouses (DWs) are complex systems having consolidated data with an objective to assist the knowledge workers in decision making process. The key components of DWs are the Extraction-Transformation-Loading (ETL) processes. As incorrect or misleading data may produce wrong decisions it necessitates the selection of appropriate ETL Tools for a DW to improve data quality. The selection of ETL tool is a complex and important issue in data warehousing because it validates the quality of a data warehouse. This paper first highlights the ETL process briefly then discuses some of the ETL tools available along with a general criterion used as measuring parameters for selecting appropriate ETL tools. At the end an analysis of the tools based on the generalized criteria is presented to give an insight of which tool is better for which circumstance.
ETL tools complex Systems enterprise systems Dataware houses
Sana Yousuf Sanam Shahla Rizvi
Department of Computer Science Military College of Signals National University of Science & Technology (NUST) Islamabad, Pakistan
国际会议
重庆
英文
251-255
2011-01-21（万方平台首次上网日期，不代表论文的发表时间）