ETL TOOLS

The term ETL which stands for extract, transform, and load is a three-stage process in database usage and data warehousing. It enables integration and analysis of the data stored in different databases and heterogeneous formats. After it is collected from multiple sources (extraction), the data is reformatted and cleansed for operational needs (transformation). Finally, it is loaded into a target database,data warehouse or a data mart to be analyzed. Most of numerous extraction and transformation tools also enable loading of the data into the end target. Except for data warehousing and business intelligence, ETL Tools can also be used to move data from one operational system to another... The purpose of the extraction process is to reach to the source systems and collect the data needed for the datawarehouse... ETL tools implementation in a data warehouse environment - articles on business intelligence, data integration, datawarehousing, data quality and information management.