Informatica PowerCenter Valuable Features

Ricardo Pedro
Solutions & Achitecture Data Analyst Specialist at a construction company with 10,001+ employees
The two most important components are the building and integration. On top of that, you can clean and analyze your data to make sure that you don't have any corruption. In the end, you have structured, proper data for use in an integrated BI solution. View full review »
MohamedKhamis
Data Scientist at IME
There are two valuable features. The first is the main typical functionality that the PowerCenter gives, that is the ETL. The ETL is able to extract transform load from/to a variety of sources, like Oracle, Microsoft's SQL Server, and Big Data. The second is the capabilities of the GUI interface; drag and drop solution. It's a powerful tool and might be the first ETL tool based on Gartner to extract, transform, and load data operations. View full review »
AmanyEldaly
Data Engineer at a tech services company with 51-200 employees
The solution is a very helpful product for data integration. The partitioning and optimization to help enhance our development is a very valuable aspect of Informatica PowerCenter. There are multiple transformations for service consumers to publish and use web services as well,In addition to the ability to implement ETL and ELT n a very easy way and finally, you have structured data for use in an integrated business intelligence solution. View full review »
Find out what your peers are saying about Informatica, Microsoft, Oracle and others in Data Integration Tools. Updated: March 2020.
406,312 professionals have used our research since 2012.
Innodirec67
Director of Innovation & Development Department at a tech services company with 51-200 employees
The solution has the best user interface and it's the most user-friendly of all data integration tools. View full review »
Vijaya Saduvuv
Lead Application Developer and Informatica Administrator at a healthcare company with 501-1,000 employees
It works with any multi-database, so it works with Sybase, SQL Server. Also, the performance is really good and it is easy to use. View full review »
Kirill Slivchikov
Owner at 7Spring Consult
The most complex task, in this case, was to read and transform BLOB data, and Java transformation in Informatica Power Center was a great solution. The second task that was solved with Java transformation was the correct transformation of the Amount field (each amount in PSQL 2000 is stored in three different fields). These tasks were solved by using PSQL 2000 Java SDK library imported to Informatica PowerCenter Java Transformation. View full review »
SeniorEtddda
Senior ETL Developer at Office of State Revenue
The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand. View full review »
Hassan Emam
Regional Manager at a tech services company with 201-500 employees
The stability of the solution is one of its best features. The user interface is also very good. View full review »
Kamal Bouyanzer
Project Manager at a comms service provider with 1,001-5,000 employees
The performance and design of Informatica have been very valuable. I find the performance faster than, Oracle Data Integrator or DataStage. View full review »
Mark Ma
Student at Ontario Ministry of Labour
* Import from PowerCenter * Copy Text between Excel and the Developer Tool * Logical Data Object Read and Write Mapping Editing * DDL Query * Profiles View full review »
Chiranjeeva Reddy
ETL Reporting Analytics Consultant at Accenture
The most valuable features are the dynamic reading of the file metadata profile, and the ability to define business rules that are used to verify and validate the uploaded files. View full review »
reviewer1215849
Senior Associate at a tech consulting company with 1,001-5,000 employees
The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed. View full review »
Find out what your peers are saying about Informatica, Microsoft, Oracle and others in Data Integration Tools. Updated: March 2020.
406,312 professionals have used our research since 2012.