For effective and efficient data management, ETL tools in data warehouse perform extraction, transformation as well as loading of data. All the three steps are designed for cleaning, filtering, sorting, splitting, deduplication and summarization of data for achieving the best data integration. Once these steps are complete, data gets stored in a data warehouse. This warehouse is a repository of final information from where data can be picked up immediately for reaching business decisions.