What do you like best?
I have used Informatica for about two years at my previous workplace. It is the best ETL Technology I have used. Some of the features that were very helpful to me
-> Access and ability to read data from multiple sources. Name the type of source and Informatica can read it.
-> The GUI is excellently simple. High on usability if I could say.
-> The expressions are many. I have used other ETL tools and I haven't found as many data manipulation expressions as in Informatica.
-> Ease of creating and using parameters.
-> Informatica PDO makes things so easier and simple to debug for errors or Data manipulations discrepancies.
What do you dislike?
There was no feature that I disliked much.
Sometimes, I would feel to write a simple statement with a aggregation and the filter is all the steps to be done in Informatica necessary. Its a simple SQL Statement.
Recommendations to others considering the product
A definite product to try for the Data Person of the company.
What business problems are you solving with the product? What benefits have you realized?
It was a full fledged project. The project was to measure the success of services. Informatica was primarily used an ETL tool to crunch the data into a database for the relevant metrics.
Some of the befits that we saw -
-> Data residing across various databases and flat files easily synched to a single application layer
-> Easier manipulation of data
-> Faster to learn and implement than SQL
-> Easier and multiple methods of transportation of packages across various environments.