PENERAPAN DATA LINEAGE UNTUK MEMINIMALISIR KESALAHAN PROSES ETL DARI BASIS-DATA SUMBER KE BASIS-DATA TARGET

Abstract

In an era of expanding information technology, data needs become very basic and important to keep in legitimacy. Moreover, many demands from the company so that the data collected and received from database source must be kept in authenticity. Data lineage implementation allows to prevent from inevitable error of ETL (Extract-Transform-Load) process from database source into target, or it can be utilized as an audit trail. In this study tried to assess its utilization using experimental and quantitative methods, where data will be collected and simulate using special software, as well as further observation of its testing results, and seeking its relevance from references. With this research, hopefully will be able to provide the best solution and can find the root cause that often occur in the source due to inconsistent data that can be, so that one day it can be used as a lesson learned from result of analysis.

Keyword: data lineage, database, source, target.