An Object Oriented Modeling and Implementation of Web Based ETL Process

The data warehousing environment includes components that are inherently technical in nature. These cleansing components function to extract, clean, model, transform, transfer and load data from multiple operational systems into a single coherent data model hosted within the data warehouse. The analytical environment is the domain of the business users who use application to query, report, analyze and act upon data in the data warehouse. The conventional process of developing custom code or scripts for this is always a costly, error prone and time-consuming. This paper proposes a web based frame work model for representing extraction of data from one or more data sources and use transformation business logic, load the data within the data warehouse.