Informatica Power Center review
April 12, 2019

Informatica Power Center review

Gurcan Orhan | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Informatica Enterprise Data Integration

Informatica Power Center is easy to understand, gives you the opportunity to perform fast development, and also supports a multi-user development environment with a check-out/check-in mechanism. It performs transformation levels of ETL (Extract & Transform & Load) very fast.
Advanced security features also help you to perform administration more easily and with confidence.
  • Transformation speed.
  • Supports a multi-User development environment.
  • A fast learning curve.
  • It needs additional hardware.
  • Lots of windows sometimes reduce your focus.
  • It would be better to have a more compact design with the ability to aim toward specific topics.
  • It works seamlessly with other Informatica products (i.e. Metadata Management, Data Quality).
  • Since data is read and written through the network, when you cannot perform E-LT you'll need more hardware.
  • Good for a multi-user development environment.
Informatica Power Center was already selected by my company before me. I just learned the software and started using it.
If you have many developers who will use Informatica Power Center for more than 80% of their work, multi-user development will reduce your administration effort with less chance of losing code.
When data is loaded to the Informatica Application Server, transformations perform very fast. It also supports push down ETL if your ETL mappings are simple or have average complexity.

Informatica PowerCenter Feature Ratings

Connect to traditional data sources
10
Connecto to Big Data and NoSQL
Not Rated
Simple transformations
9
Complex transformations
7
Data model creation
Not Rated
Metadata management
10
Business rules and workflow
10
Collaboration
10
Testing and debugging
9
Integration with data quality tools
10
Integration with MDM tools
10

Using Informatica Enterprise Data Integration

Positives;
- Multi User Development Environment
- Speed of transformation
- Seamless integration between other Informatica products.

Negatives;
- There should be less windows to maintain developers' focus while using. You probably need 2 big monitors when you start development with Informatica Power Center.
- Oracle Analytical functions should be natively used.
- E-LT support as well as ETL support.

Informatica Enterprise Data Integration Reliability

Positives;
- Multi-user development environment.
- The speed of transformation.
- Seamless integration with other Informatica products.

Negatives;
- There should be fewer windows, to maintain developers' focus while using. You probably need two big monitors when you start development with Informatica Power Center.
- Oracle Analytical functions should be natively used.
- E-LT support as well as ETL support.