Extract transformation loading from OLTP to OLAP data using pentaho data integration

Open

R.J. Salaki, J. Waworuntu, I.R.H.T. Tangkawarow

2016 IOP Conference Series: Materials Science and Engineering Vol. 128 Issue 1 Conference paper Cited by 10 Quartile

Abstract

The design of the data warehouse in this case is expected to solve the problem of evaluation of learning results as well as the relevance of the information received to support decision-making by the leader. Data warehouse design is very important, which is designed to utilize the existing resources of information. GPA (Grade Point Average) data warehouse can be used for the process of evaluation, decision making and even further planning of the study program of PTIK. The diversity of data sources in the course PTIK make decisionmaking and evaluation process becomes not easier. Pentaho Data Integration is used to integrate data in PTIK easy. CPI data warehouse design with multidimensional database modeling approach using the dimension tables and fact tables. © Published under licence by IOP Publishing Ltd.

Affiliations

Pendidikan Teknologi Informasi Dan Komunikasi, UNIMA, Manado, Indonesia