Informatica PowerCenter Reviews & Product Details

It is quite easy to use once you get a hang of it and has a bunch of features. although initially it is indeed a bit overwhelming with a lot of things and one can take months to get aware of most of the features(not all). Have the option of selecting different types of sources and targets and can integrate with other applications as well. Integration of different databases all under one roof is very nice. Review collected by and hosted on G2.com.

**Several times the error logs, when the session fails are not very intuitive and one has to dig deep in order to figure out where the problem is. There should maybe some kind of better documentation to help resolve issues.

**Also, it's a bit pricey, I think, especially from the smaller firms' POV. So, if it wishes to in-future provide for the smaller firms as well, maybe a different kind of less expensive model would be great.

**Also, sometimes the designer gets stuck, whenever I try to open some repository that might be having several sub-folders, it takes several minutes to just open one repository.

**And sometimes it gets stuck on the designer in a particular mapping and becomes unresponsive and one has no option but to completely close it and open it again in Citrix, and maybe at times, lose the changes done to a particular mapping as well.

** The UI might need to be modernized a bit, since it seems pretty old Review collected by and hosted on G2.com.

I have been using this tool for more than two years for processing structured and semi-structured data into Teradata data warehouse. I have been involved in various Data Integration, Data Management, Data Migration using this, and I find the UI to be friendlier. It has a lot of components and functionalities that will help you to achieve almost everything related to transforming data. Review collected by and hosted on G2.com.

If you are processing less volume of records from ODBC, then it might lag its performance. Does not have much scheduling options for the workflows. Needs additional hardware while partitioning. Review collected by and hosted on G2.com.

It's easy to manage any workflow. For example if a workflow is failed then one can check the logs to the error of a particular workflow session. You can also easily rerun a workflow from the failed session. Review collected by and hosted on G2.com.

I don't like how I have to switch back and forth between Informatica manager and monitor to see the the order of the workflow sessions. Review collected by and hosted on G2.com.

Best thing I liked about Informatica is its mapping options and user interface it is providing. It provides many ways to implement your job. The performance and data transformation options it is providing are at its best. The connections and compatibility with different databases is so good. One can easily understand Informatica because of its simplicity yet standard. Review collected by and hosted on G2.com.

I felt like everything we have to do on our own and it is not doing any automatic things and we have to consider many things while developing which will take our tome. Review collected by and hosted on G2.com.

Informatica PowerCenter is one of the best and reliable ETL platforms for pulling data from multiple sources and it creates a powerful and strong data warehouse. I am using Informatica PowerCenter for pulling the data from heterogeneous sources and created a very strong and powerful data warehouse for data analysis and campaign operation. Its easy to use and drag and drop features make him a very strong ETL platform in the market. Review collected by and hosted on G2.com.

I have not faced any issues or challanges while using this ETL platform. Everything is perfect and stable with Informatica PowerCenter. Review collected by and hosted on G2.com.

Performance is good with informatica etl tool Review collected by and hosted on G2.com.

Mdm is bit complex to understand the technology Review collected by and hosted on G2.com.

The product is simple and easy to use. Supports a variety of sources for data integration. Out-of-the-box integration is provided for multiple sources. Integration could be done using APIs as well. Review collected by and hosted on G2.com.

Very slow, some tasks need to be done online only, and local changes are not allowed. Pricing seems to be on the higher side. Review collected by and hosted on G2.com.

It is straightforward to use Informatica Power Centre, and it is very intiutive. We can pull files of various formats and styles, process those files to fetch the data, and then modify the data present in the file according to the requirement. It is pretty easy to schedule the maestro job and run it any time. Review collected by and hosted on G2.com.

Often, it is a little challenging to read log files and find out the error. Transaction rework takes a longer time, and the cost to implement a new design is high. The customer support is not very quick and takes a long time. Review collected by and hosted on G2.com.

Best ETL type data integration tool that connects to almost all types of databases. Development, Testing, and maintenance are easy to monitor. Transformation speed is pretty high. Review collected by and hosted on G2.com.

Complexity during deployment. Transformation along with data ingestion takes comparatively larger time for the immense amount of data. Blobs file handling is complex Review collected by and hosted on G2.com.

UI and ease of working on the tool developer-friendly. Enhancements and new features are good to have. Prompt assistance &technical support. Review collected by and hosted on G2.com.

performance issues, Due to its Huge UI burden Performance degrades and causes issues while loading more frequently compared to traditional DW Tools. Review collected by and hosted on G2.com.