A Study on Informatica Tool for Extract, Transform and Load processes of Data Warehouse
Nirali Shah1, Vinaya Sawant2
1Nirali Shah, Department of Information Technology, Dwarkadas J. Sanghvi college of Engineering, Mumbai, India.
2Vinaya Sawant, Department of Information Technology, Dwarkadas J. Sanghvi college of Engineering, Mumbai, India.
Manuscript received on November 12, 2014. | Revised Manuscript received on December 15, 2014. | Manuscript published on December 25, 2014. | PP:1-5 | Volume-3, Issue-2, December 2014. | Retrieval Number: B0862123214
Open Access | Ethics and Policies | Cite
© The Authors. Published By: Blue Eyes Intelligence Engineering and Sciences Publication (BEIESP). This is an open access article under the CC BY-NC-ND license (http://creativecommons.org/licenses/by-nc-nd/4.0/)
Abstract: The relational database enabled access to the valuable information contained deep within data. Still improvements were needed for optimized complex reporting or analytical needs. This lead to the revolution of Data warehouse which would store current and historical data that could be used for creating analytical reports and analyzing hidden trends. As data is growing, companies will be required to adopt data warehouses so as to manage these huge stacks of data and hence Informatica can help them in building data warehouse. This paper focuses on ETL process of data warehouse and how Informatica is used for these processes using a case study on TAB Taxi to understand the working of this tool methodically. Informatica is a powerful tool for extracting the source data and loading it into the target after applying the required transformation.
Keywords: Data warehouse, ETL, Informatica, Extract, Transform, Load etc.