Study on the Performance Criteria of a Datawarehouse In A Company: Analysis of ETL Models and Perspectives

This article discusses the performance of a data warehouse as well as the analysis of the generation of ETL (Extract-Transform-Load) operators to feed a data store from a relational data source.First, we add new rules to those proposed by the authors, these rules deal with the combination of ETL operators.Secondly, we propose a hybrid partitioner of the Vassiliadis approach based on model transformation for the generation of ETL operations necessary for loading a data warehouse.This approach offers the possibility to the designer to define certain conditions necessary for loading.