Conceptual and Logical Models for Performing Extraction, Transformation and Loading Process in a Data Warehouse

Extraction, Transformation and Loading process is the important phase in building a data warehouse. This phase helps in integrating the heterogeneous data sources at a unified schema after transforming it into the desired format and at the same time handling various issues related to data quality. Researchers have proposed various conceptual models as well as logical models to perform this task. Through this research work, an attempt has been made to explore all the conceptual and logical models. Further, a qualitative comparative study of these models has been performed, which reveals the strengths and weaknesses of the entire model set. In addition to this, features that should be incorporated in conceptual and logical modeling of ETL process have also been highlighted through this study.