Extraction-Transformation-Loading (ETL) processes are responsible for all the operations taking place at the warehouse. The ETL is done by specialized tools that deal with the extraction of the data from various database sources and then cleaning it and transforming it to be stored in the data warehouse. These sophisticated tools though available in the market are not developed by any standardized parameters and every organization has specific data and with this the problems associated with the ETL tools are varying according to the organization. The main objective of this paper presents an insight into the different methodologies being used for data integration along with the limitations of the ETL tools. A suggestive framework is also being presented for better efficiency of the data integration tools with the business intelligence.
ETL tools, ETL process, data warehouse, Business Intelligence
