Extract Transform Loading (ETL) Based Data Quality for Data Warehouse Development

Extract Transform Loading (ETL) plays a decisive role in data warehouse (DW) construction. It involves retrieval informations from multiple sources to improve information quality in DW for decision making process. A DW development relies on the development of ETL. Therefore, ETL conceptual model not only represents an overview of overall process, but also as a mapping amongst data sources, DW targets and required transformation to make sure that data quality (DQ) dimensions are incorporated in order to meet the requirements. In this paper, an ETL framework is proposed which incorporates data quality to improve information processes in data warehouse development through ‘the story’ of process whilst others framework more to technical approach. In order to be useful, the proposed framework compared with other framework in case of advantages and disadvantages for future improvement.