Balijepalli, Saketh2019-07-172019-07-172019https://hdl.handle.net/1794/24786Data integration is a digital technology used to combine data from multiple sources and provide users with a unified view of data assets (Chen, Hu, & Xu, 2015; Davidovski, 2018). Data is typically loaded into a data warehouse via Execute-Transform-Load (ETL) operations (Hose et al. 2015); sometimes the transformed data lacks data integrity. This paper explores best practices in using semantic transformation to address data integrity issues caused by data integration.enCreative Commons BY-NC-ND 4.0-USData integrationETLSyntactic transformationSemantic transformationBusiness intelligenceData analyticsSemantic ETLData warehouseSemantic informationData integrityTerminal Project