Articles uploaded in MyJurnal |
|
|
View Article |
Extraction Transformation Load (ETL) solution for data integration: a case study of rubber import and export information
Mimi Safinaz Jamaluddin1, Nurulhuda Firdaus Mohd Azmi2.
Data integration is important in consolidating all the data in the organization or outside the organization to provide a unified view of the organization's information. Extraction Transformation Load (ETL) solution is the back-end process of data integration which involves collecting data from various data sources, preparing and transforming the data according to business requirements and loading them into a Data Warehouse (DW). This paper explains the integration of the rubber import and export data between Malaysian Rubber Board (MRB) and Royal Malaysian Customs Department (Customs) using the ETL solution. Microsoft SQL Server Integration Services (SSIS) and Microsoft SQL Server Agent Jobs have been used as the ETL tool and ETL scheduling.
Affiliation:
- Universiti Teknologi Malaysia, Malaysia
- Universiti Teknologi Malaysia, Malaysia
Toggle translation
Download this article (This article has been downloaded 119 time(s))
|
|
Indexation |
Indexed by |
MyJurnal (2021) |
H-Index
|
6 |
Immediacy Index
|
0.000 |
Rank |
0 |
Indexed by |
Scopus 2020 |
Impact Factor
|
CiteScore (1.4) |
Rank |
Q3 (Engineering (all)) |
Additional Information |
SJR (0.191) |
|
|
|
|
|