Volume 1 Number 4 (Oct. 2009)
Home > Archive > 2009 > Volume 1 Number 4 (Oct. 2009) >
IJCEE 2009 Vol.1 (4): 488-495 ISSN: 1793-8163
DOI: 10.7763/IJCEE.2009.V1.74

Statistically Analyzing the Impact of Automated ETL Testing on the Data Quality of a Data Warehouse

Jaiteg Singh and Kawaljeet Singh

Abstract—For truthful reporting and decision-making a major challenge in data warehouse industry is to ensure quality data. The Extraction, Transformation and Loading (ETL) module is crucial to attain high quality data for a data warehouse. In-house development of ETL solutions with improvised algorithms may result in unknown errors at logical or technical levels. To assure data quality one has to understand the prevailing data quality assurance practices. This paper is intended to empirically analyze the impact of automated ETL testing on the data quality of the data warehouse. The data quality was observed before and after the induction of automated ETL testing. Statistical analysis indicated a substantial escalation in data quality after the induction of automated ETL testing.

Index Terms—ETL, ELT, Data Warehouse, ETL Test Cases

Jaiteg Singh is with Punjabi University Patiala, India as research Scholar.Tel: 0091-9872029991
Dr. Kawaljeet Singh is presently with Punjabi University Patiala, India, working as Director in the University Computer Center.

Cite: Jaiteg Singh and Kawaljeet Singh, "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, pp. 488-495, 2009.

General Information

ISSN: 1793-8163 (Print)
Abbreviated Title: Int. J. Comput. Electr. Eng.
Frequency: Quarterly
Editor-in-Chief: Prof. Yucong Duan
Abstracting/ Indexing: EI (INSPEC, IET), Ulrich's Periodicals Directory, Google Scholar, EBSCO, ProQuest, and Electronic Journals Library
E-mail: ijcee@iap.org

What's New

  • Jun 03, 2019 News!

    IJCEE Vol. 9, No. 2 - Vol. 10, No. 2 have been indexed by EI (Inspec) Inspec, created by the Institution of Engineering and Tech.!   [Click]

  • Oct 11, 2019 News!

    IJCEE Vol 11, No 4 is available online now   [Click]

  • Oct 11, 2019 News!

    The dois of published papers in Vol 11, No 1- Vol 11, No 3 have been validated by Crossref

  • Aug 20, 2019 News!

    IJCEE Vol 11, No 3 is available online now   [Click]

  • Jun 03, 2019 News!

    IJCEE Vol. 11, No. 2 is available online now.   [Click]

  • Read more>>