J. Today’s Ideas - Tomorrow’s Technol.

A Review of Contemporary Data Quality Issues in Data Warehouse ETL Environment

Rupali Gill, Jaiteg Singh

  • Download PDF
  • DOI Number

Data inconsistency, identification of errors, organization growth, ETL, data quality

PUBLISHED DATE December 2014
PUBLISHER The author(s) 2014. This article is published with open access at www.chitkara.edu.in/publications

In today’s scenario, Extraction–transformation– loading (ETL) tools have become important pieces of software responsible for integrating heterogeneous information from several sources. The task of carrying out the ETL process is potentially a complex, hard and time consuming. Organisations now –a-days are concerned about vast qualities of data. The data quality is concerned with technical issues in data warehouse environment. Research in last few decades has laid more stress on data quality issues in a data warehouse ETL process. The data quality can be ensured cleaning the data prior to loading the data into a warehouse. Since the data is collected from various sources, it comes in various formats. The standardization of formats and cleaning such data becomes the need of clean data warehouse environment. Data quality attributes like accuracy, correctness, consistency, timeliness are required for a Knowledge discovery process. The present state -of –the- art purpose of the research work is to deal on data quality issues at all the aforementioned stages of data warehousing 1) Data sources, 2) Data integration 3) Data staging, 4) Data warehouse modelling and schematic design and to formulate descriptive classification of these causes. The discovered knowledge is used to repair the data deficiencies. This work proposes a framework for quality of extraction transformation and loading of data into a warehouse.


Business today forces the enterprises to run different but coexisting information systems. Correct information is the most imperative resource in many enterprises for the business success. Decision support and business intelligence systems are used to mine the data in order to obtain knowledge that supports the decisiontaking process affecting the future of a given organization. a data warehouse is a class of relational database that is designed for analytical processing rather than for transaction processing. It usually contains historical data derived from transaction data, but it can include data from other sources. It separates analysis workload from transaction workload and enables an organization to consolidate data from several sources. The challenge in data warehouse environments is to integrate, rearrange and consolidate large volumes of data over many systems, to provide a unified information base for business intelligence.

The process of extracting data from source systems and bringing it into the data warehouse is commonly called ETL, which stands for extraction, transformation, and loading. In ETL data is extracted from different data sources, and then propagated to the DSA (Data Staging area) where it is transformed and cleansed before being loaded to the data warehouse. Source, staging area, and target environments may have many different data structure formats as flat files, XML data sets, relational tables, non-relational sources, web log sources, legacy systems, and spreadsheets. To work in an operational environment several quality issues have been seen in an ETL environment. Cleansing data of errors in structure and content is important for data warehousing and integration. Current solutions for data cleaning involve many iterations of data “auditing” to find errors, and long-running transformations to fix them. There are various approaches used in cleaning data in manufacturing industries, schools/colleges/universities, organizations and many more. users need to endure long waits, and often write complex transformation scripts.

Page(s) 153-160
URL http://dspace.chitkara.edu.in/jspui/bitstream/1/498/3/22007_JOTITT_Rupali.pdf
ISSN Print : 2321-3906, Online : 2321-7146
DOI https://doi.org/10.15415/jotitt.2014.22012

Data quality has become a major concern activity performed by most organizations that have data warehouses. every organization needs quality data to improve on its services it renders to its customers. In view of this a thorough review of approaches and papers in that regard are discussed and their limitations also stated. This is to help future development and research directions in the area of data cleansing. The papers reviewed in this report looked at critical aspects of data quality and the various types of data that could be cleansed.

  • Chinta Someswara Rao, J Rajanikanth, V Chandra Sekhar, Bhadri Raju MSVS (2012) “Data Cleaning Framework for Robust Data Quality in Enterprise Data Warehouse” , IJCST e- ISSN: 0976-8491 p. ISSN : 2229-4333, Vol. 3, Issue 3, pp. 36-41
  • K. Srikanth , n.v.e.s Murthy, J. Anitha (2013) “ Data Warehousing Concept Using etl Process For scd Type-3” International Journal of Emerging Trends & Technology in Computer Science (ijettcs) Issn: 2276-6856, Vol. 2, Issue 5, pp. 142-145.
  • Kabiri A.; Chiadmi D. (2013) “Survey on ETL Processes”, Journal of Theoretical and Applied Information Technology. Vol. 54, No. 2
  • P andey K.Rahul (2014). Data Quality in Data warehouse: problems and solution.IOSR-Journal of Computer Engineering, Volume 16, Issue 1, pp. 18-24.
  • Rahm, E., Do, H.H. (2000). Data Cleaning: Problems and Current Approaches. IEE Data Engineering Bull. Vol 23 No. 4, pp. 3-13
  • Rodi´c J.; Baranovi´c M. (2009) “Generating Data Quality Rules and Integration into ETL Process”, DOLAP’09 ACM
  • Sakshi Agarwal ‘Reasons of Data Quality Problems in Data Warehousing’ International Journal of Computer, Information Technology & Bioinformatics (ijcitb) issn: 2278-7593, Volume-1, Issue-4 ieee & ieee Computational Intelligence Society, 2013.
  • Saravanan p. (2014) “An Iterative Estimator for Predicting the Heterogeneous Data Sets”, Weekly Science Research Journal issn: 2321-7871, Volume 1, Issue 27, pp. 1-15.
  • Satkaur; Mehta a.(2013) “a Review Paper on scope of etl in retail domain”, International Journal of Advanced Research in Computer Science and Software Engineering 3(5), ijarcsse, pp. 1209-1213.
  • Singh J.; Singh K. (2009) “Statistically Analyzing the Impact of Automated ETL Testing on the Data Quality of a Data Warehouse”, International Journal of Computer and Electrical Engineering, Vol. 1, No. 4.
  • Singh R.; Singh K. (2009). A Descriptive Classification of Causes of Data Quality Problems in Data Warehousing International Journal of Computer and Electrical Engineering, Vol. 1, No. 4
  • Srikanth k.; Murthy n.v.e.s.; Anitha j. (2013) “Data Warehousing Concept Using etl Process for scd Type-2”, American Journal of Engineering Research (ajer) e-ISSN: 2320-0847 p-ISSN: 2320-0936, Volume-2, Issue-4, pp. 86-91’ 2013.
  • Sujatha.R (2013) “Enhancing Iterative Non-Parametric Algorithm for Calculating Missing Values of Heterogeneous Datasets by Clustering”, International Journal of Scientific and Research Publication issn: 2250-3153, Volume 3, Issue 3, pp. 1-4.
  • Vassiliadis P.; Simitsis A.; Baikousi E. (2009) “A Taxonomy of ETL Activities” DOLAP ‘09 Proceedings of the ACM twelfth international workshop on Data warehousing and OLAP, pp 25-32.
  • H eiko Muller, Johann-Christoph Freytag. (2003). Problems, Methods, and Challenges in Comprehensive Data Cleansing, pp. 21.
  • Vassiliadis P.; Simitsis A.; Skiadopoulos S.(2002) “Conceptual Modeling for ETL Processes”, Proceedings of the ACM tenth international workshop on Data warehousing and OLAP, pp. 14-21.