Proposed Techniques to Optimize the DW and ETL Query for Enhancing data warehouse efficiency

Abstract— To improve time-bound decision capability of any
business corporates, they have to perform data-analysis based
on historical and current data. For handling this data, data
warehouse (DWH) plays a crucial role. Further-more as time
passes, the data also grows exponentially, because in data
warehouse historical data also needs to be maintained. If we
further drill now-a-days Extract Transform and Load (ETL)
tools are being used to perform extract, transform and loading
of data. These ETL tools are based on any specific language like
in case of Informatica ETL tool, which is based on Structured
Query Language (SQL) language. So, it’s imperative to enhance
the efficiency of these languages to enhance the capacity of ETLtools and this will significantly impact the performance of datawarehouse ETL work, and by this data can also be provided infaster manner for analysis and reporting urposes.Additionally, data quality is also an important factor, as data-analysis will be performed on the same data supplied by datawarehouse. So, it’s highly concerned to improve the data qualityby applying data-quality checks before supplying