2020 · 23 citations · 3 references
ComputingInformation SystemsInformation TechnologyData ManagementEnterprise SystemsEnterprise Systems EngineeringData IntegrationData WarehousingDatabase ManagementExtract, Transform, LoadWarehouse ManagementWarehousing ManagementExtract, Transform, Load (Etl)Extract, Transform, Load (Etl) ArchitectureTransform (Etl) Processes
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.
3
Sari Wahyuni · 2012 · 182 citations