Architecture of Data Warehouse ETL Tools- Performing Efficient and Effective Way
Data warehousing has been a buzz word in the industry since mid 90's, but it was not wide spread due to be complex timing and maintenance. Business and technologies are now wider and wider so in modern technologies users cannot think in any organization without data warehouse. Data warehouse helps users to analyze and reporting data for decision making purpose. OnLine Transactional Processing (OLTP) can't store data for a long time. For reason the OnLine Analytical Processing (OLAP) is now become popular. The authors develop an architectural model for data warehouse ETL tools, which help them to Extract, Transform and Load in an efficient and time consuming way.