International Journal of Computer Applications |
Foundation of Computer Science (FCS), NY, USA |
Volume 169 - Number 5 |
Year of Publication: 2017 |
Authors: Farhad Alam, Sanjay Pachauri |
10.5120/ijca2017914754 |
Farhad Alam, Sanjay Pachauri . FME Enabled ETL Processes for Spatial and Attribute Data Analysis. International Journal of Computer Applications. 169, 5 ( Jul 2017), 31-35. DOI=10.5120/ijca2017914754
ETL is a type of data integration that refers to the three steps (extract, transform, and load) used to blend data from multiple sources. It's often used to build a data warehouse. During this process, data is taken (extracted) from a source system, converted (transformed) into a format that can be analyzed, and stored (loaded) into a data warehouse or other system. FME has a rich data model designed implement ETL. FME provides tremendous transformation functionality, resulting in output that can be much greater than the sum of the inputs, and allowing data to be transformed from one type to another. The current paper uses FME workbench and implement the concept of ETL using a case study where a private firm wants to integrate attribute and spatial information regarding its employee, filter the unnecessary information and finally implement business query regarding Monthly Travelling Allowance. The results establish ETL and FEM as interdisciplinary technological domain and backbone of the data warehouse architecture.