The solution has proved to be an excellent ETL tool for our organization. It is also easier for our higher management to get an overview of the backend activity.

I'm pretty focused on narrow processes, including realizing business requirements connected to particular workflows. 

Improved the data integrity, data flow and data managment with consummption too made easy and ustainanble and scalable.

We use Informatica PowerCenter to transfer the transitional database to and from the data warehouse. This is very efficient as it enables us to quickly find our data reports and the data, so we can build AI models.

It helps with the automation process. We have a lot of requests from the user to create for them data alerts. We have had some success using Informatica. 

We have different sources of files coming, sometimes from the mainframe, and Informatica is very useful for accepting different sources, such as spreadsheets and databases, and doing the transformation. Libraries are also helpful. I also managed to go into the database and create my own transformations for mapping automatically.

Our organization had to import data from AS400, implement a sales cost analysis and load data into Data Mart, which was further consumed by QlikView. This was done with data from five different countries in different time zones. From the point of developing mapping, replicating them for other countries given their respective databases to loading the data, everything was automated and scheduled with notification about the loads. It changed the way we did business. Customers orders, modification, and tracking was all smooth. Every morning, we would receive one e-mail with consolidated load statistics and it all starts with one e-mail.

It is UI friendly and has all the advantages of an ETL tool. In addition, integration is possible between Oracle and SQL.

It is also relatively expensive but is worth the price because the software provides a good experience. The resources we need exist, and the people are available.

Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years. Informatica administrators are in the scope of daily operations.

We used Informatica PowerCenter for a re-platforming project where the earlier application was using an in-house Java-based ETL, that suffered in terms of the performance and scalability issues. With Informatica PowerCenter, we were able to overcome all the performance bottlenecks and we were able to standardize the ETL layer. The re-platformed application was able to complete the high volume batch data load in minutes, compared to the long hours it took in the old application. In addition, the year-end volume spikes are easily handled by Informatica.

It has helped us meet our monetization needs. 

It reduces a lot of legacy coding.

Using Informatica PowerCenter, we can create workflows, tasks, and more. Performance is improved while developing ETL solutions and mappings can be done easily because of the UI features.

Informatica PowerCenter moved forward the technology level of ETL-process management of the bank with visualization and standardization of ETL development instead of a huge volume of scripting used previously. Moreover, the task of integration of systems based on different technology platforms was successfully solved.

This is the best tool that we have.

Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse.

With this product we can centralize all our ETL needs in one technology. One unique team with the right expertise is responsible for developing, implementing, and tuning it. We eliminated the variety of different solutions and different technologies. This means that the knowledge and skills are not spread-out.

Informatica PowerCenter satisfies our customers need; thus making Extract Transform Load from data base to data warehouse based on specific business rules.

We are trying to implement both Finance and Operations modernization with the help of Informatica. This tool is mainly used in data ingestion, where we bring different sources into a Hadoop environment.

Like any other ETL tool, it collects business information for centralized reporting and analytics.

Ease and speed of building integrations, especially integrations between different applications, such as our Hospital Information System. 

This solution has allowed my client to see the real benefits of dynamically reading the profile to verify the file structures.

Using this solution has given us better performance than just purely using PL/SQL.