International Journal of Engineering and Technology

Data warehouse (DW) has been widely recognized as an effective solution for integrating diverse sources. In this environment, Extraction Transformation Loading (ETL) processes constitute the integration layer. They perform data extraction, their cleaning, their conforming and loading into the target. It is widely recognized that building ETL processes, in a data warehouse project, are expensive regarding time and money. In spite of the abundance of works and proposals, around ETL, there is no proposal towards a global approach taking in account the cost and the complexity of ETL processes. In this context, we propose in this paper, a framework called KANTARA for managing ETL processes based on our experience in real world.