Complex transformations can be easily achieved by using PowerCenter. The processing layer does transformations and other things. About 80% of my transformations can be achieved by using the middle layer. For the remaining 15% to 20% transformations, I can go in and create stored procedures in the respective databases. Mapplets is the feature through which we can reuse transformations across pipelines. Transformations and caching are the key features that we have been using frequently. 

Informatica PowerCenter is one of the best solutions or products in the data integration space. We have extensively used PowerCenter for integration purposes. We usually look at the best bridge solution in our architecture so that it can sustain for maybe a couple of years. Usually, we go with the solution that fits best and has proven and time-tested technology.

What I like most about Informatica PowerCenter is that it enables integration and connection with multiple new systems, both structured and semi-structured. I also find its adapters for multiple source systems valuable. Its features meet industry standards. It is a proven high-performing enterprise-scale ETL solution.

Real time is amazing. If you have AI use cases, you can predict if it's a threat or if it's a positive or negative transaction. You can use real time with PowerExchange to write data directly to Kafka, to consume, write, or parse data using an AI algorithm to detect if the data is positive or negative and to define what use cases you want. 

They know what they're doing, and it's a more mature tool compared to Talend. They really think about every scenario. For example, if you want to write a data cleansing algorithm and all that is probably rules. It's just easier. There are a lot of provisions in PowerCenter. In terms of the transformation algorithms and all that, there are a lot of operations. It's great.

The solution is stable.

It's a scalable product.

One of the most valuable features for us is the metadata repository because it can easily understand the lineage of first target mapping. My company and I also find Informatica really easy to use—when a consultant joins our company, in just a few days to a few weeks, they can understand how to use it—so we prefer to use this ETL tool. 

It's a very powerful tool you can use to load data, get data, do the drawing between the tables, and put it into the packet in a very fast way.

So for this client, we are using the MDM (Master Data Management), and the PowerCenter will be very helpful in building data and merging all the data between the different systems they have. They have a lot of systems that contain the same information and we want to put that into a single place. This is the most valuable feature of this solution which has been of great help to us.

From my point of view, the solution has two valuable features. It has the ability to manage a huge quantity of data along with a high level of reliability from a performance point of view. Secondly, it has all the tools and features within the platform to establish a real data governance strategy. That includes lineage data preparation, ETL, ELP, everything regarding monitoring and processes that are implemented in the platform. It's quite feature full in that regard.

The greatest feature is that it is very easy to have someone come in and jump right in. It is one of the nicest tools in terms of getting a person acquainted quickly.

The most valuable features are that it is quick and easy to use. Anybody can master it in a short time.

The interface is very clean and clear.

This tool integrates with distributed systems.

The support is valuable. There are also open-source ETL products, which work very well, but there is no support. When we face a production problem, being able to get support is valuable, and it brings efficiency. With an open-source solution, we can't engage anyone to resolve the problem as quickly as possible.

Its stability is high, and it is also scalable.

The most valuable features are the metadata repository and the data warehouse application console.

The most valuable feature of Informatica PowerCenter is the flow designer functionally. It is the best out of any ETL tool. Additionally, the solution is reliable and trustable in dealing with large data sources anytime. When we're using billions of data transactions, it's smooth. 

I like the automated scheduling feature. Suppose we want to automate data anonymization, we have tools within PowerCenter for that. In terms of the capability of data loading features, Informatica products are better.

It is easy to use, and it is quick for developing things. It is fairly powerful, and it can integrate with a lot of different platforms without much hassle.

Once you have learned Informatica, it is very easy to use.

The feedback that I have received from team members is that they found it easy to work with.

The most valuable features are the monitoring tools and the reporting manager.

PowerCenter is the market leader, so more organizations use it than other tools. It's a feature-rich solution, so that's why it's at the top of the market.

We have found the PowerCenter and B2B data transformation most valuable. Additionally, they have many native connectors, high performance, and a lot of support documentation.

Informatica PowerCenter is a very strong tool which offers a host of features. We can use heterogeneous data to easily merge and derive the useful information. Also, flag files processing is very useful.

It's quite suitable for our needs.

It's a complete package, which is why we use this solution.

We have not had any issues with this solution.

Informatica PowerCenter is very good for integrating a huge amount of data in a very short duration, such as a minute.

It is also very easy to use. After you provide the source and the target, mappings are automatically done, which makes it easy to use for the development team.

What I like the most is that we have to deal with less while writing the queries.

The unstructured data can now be imported into Informatica PowerCenter. This is an achievement for them.

We like that it is cloud-based and the performance is good. The number of docs has been reduced drastically, which is very good.

If the systems get migrated or upgraded, the amount of resources required are very minimal. We can change the connections and establish a new connection. It's very helpful.

The most valuable aspects of Informatica PowerCenter are the many features, ease of use, and user-friendliness.

The solution provides good performance with an easy to use interface and reasonable documentation.

It has a very good graphical interface.

It has the possibility to intervene in the automatic ETL. 

It has a lot of components. 

It has a Data Catalog that uses the Model repository.