Data ware housing has been a buzz word in the industry since mid 90s, 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 we cannot think in any organization without data warehouse. Data warehouse helps us to analyze and reporting data for decision making purpose. Online transactional processing (OLTP) cant store data for a long time.For reason the Online Analytical Processing (OLAP) is now become popular. We develop an architectural model for data ware house ETL tools, which help us to Extract, Transform and Load in an efficient and time consuming way.

Md Moshiur Rahman has completed his B.Sc Engg. in Computer Science and Engineering from PSTU and M.Sc Engg. in Computer Science and Engineering at Islamic University of Technology (IUT),Gazipur, Dhaka. He is now working as a Trainee Engineer at Woojoo Telecom Ltd, Bangladesh.