A comparative study of various ETL process and their testing techniques in data warehouse. Issue 4 (4th July 2017)

• Record Type: Journal Article
• Authors: Vyas, Sonali; Vaishnav, Pragya
• Is Part Of: Journal of statistics & management systems. Volume 20:Issue 4(2017)
• Page Start: 753
• Page End: 763
• Publication Date: 2017-07-04
• Subjects: ETL -- Extraction -- Transform -- Loading -- ETL Testing -- Data warehousing; 68P99; Statistics -- Periodicals; Mathematical models -- Periodicals; Mathematical models; Statistics; Periodicals; 519.5
• DOI: 10.1080/09720510.2017.1395194
• Languages: English
• ISSNs: 0972-0510

Abstract

Abstract: Extraction–transformation–loading (ETL) tools are fraction of software which extract the data from various sources, and then it clean, customize, reformat, and integrate the data and insert into a data warehouse. ETL process in data warehousing responsible for pick data out from the operational systems and fixed it into the data warehouse. Construct the ETL process is one of the bulky tasks of construct a warehouse. In this paper we will try to explain the ETL process, ETL testing challenges and ETL testing techniques.