INFORMATICA INTRODUCTION

1. Informatica is an ETL tool (or) Integration tool
2. It is useful to Extract different Heterogeneous Sources (like Sibel, Sales force,Oracle Apps, PeopleSoft, Mainframe ….) Transform as Analytical data (Aggregating data, cleaning data…) and Load into DW.
3. In Informatica latest version is INFORMAICA 9.5
4. The earlier famous versions of informatica 9.0,8.6, 8.1, 8.0, 7.1, 6.0…
5. In Informatica we have mainly following components.
1. Informatica Administration console
2. Informatica Repository Manager
3. Informatica Designer
4. Informatica workflow Manager
5. Workflow Monitor