Comparison of the E-LT vs ETL Method in Data Warehouse Implementation: A Qualitative Study

Abstract

The data warehouse is an enterprise system that archives various kinds of data from various main systems and integrates them into a place. There are two data processing methods in implementing a data warehouse, namely ETL (Extract, Transform, Load) and E-LT (Extract, Load, Transform). In determining the implementation of a data warehouse, it is often difficult to choose the appropriate method. Because this is related to Cost, Process, Performance, and Continuous Improvement in a company. This paper discusses the implementation of a data warehouse in various industries by conducting a survey to compare the use of ETL and E-LT methods. The survey was conducted on people with backgrounds in work related to data warehouses from various industries. Based on the results of this survey, it is hoped that a better method of implementing a data warehouse can be obtained.