International forum of researchers Students and Academician
Extraction-Transformation-Loading (ETL) tools are available for the extraction of data from several sources, their cleansing, customization and insertion into a data warehouse. In this paper, the authors have focus on how to build optimized data warehouse model through Pentaho ETL tool. Initially they have taken data set that is given a problem formulation has been carried out manually and then through tool created a conceptual model and passed through ETL process and generating a snow flake schema. Optimized snow flake schema put it on data warehouse for the purpose of problem solving and decision making.