Modeling ETL Process for Data Warehouse: An Exploratory Study

The data warehouse facilitates knowledge workers in decision making process. A good DW design can actually reduce the report processing time but, it requires substantial efforts in ETL design and implementation. In this paper, the authors have focused on the working of Extraction, Transformation and Loading. The focus has also been laid on the data quality problem which in result leads to falsification of analysis based on that data. The authors have also analyzed and compared various ETL modeling processes. So this study would be substantially fruitful for understanding various approaches of ETL modeling in data warehousing.