Informatica power center the world's leader in ETL for more than 2 decades now ,provides world class functionalities for extracting the data from various sources and transforming the data using various transformation techniques and load the data to any of the target systems.
Informatica supports various source systems connections including all the leading data base systems, application systems, text files, cloud services etc.
It provides various different kinds of transformation techniques which helps transform the data in anyway the business expects.It has various transformations like source qualifier, lookup transformation, joiner transformation, normalizer, SQL transformation, TCL transformation,sorter transformations etc.
Additionally to these inbuilt transformation informatica also supports java transformation where user can write customized java code which helps to achieve the most difficult functionality.
Informatica also provides various connectors such as SAP connectors to connect to SAP applications/databases, Sales force connectors for connecting to Salesforce connectors and it provides the easy integeration with all the industry leading analytic tools which makes the implementation very easy. Review collected by and hosted on G2.com.