Good ETL Platform
April 06, 2017

Good ETL Platform

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with PowerCenter

Our company bought Informatica PowerCenter around 5 years ago, when we initially set up the BI team in the IT department. After that it became one of the core platforms in IT for data-level workflow and reporting purposea.

Pros

  • It is quite flexible to handle different type of data formats like DB objects or Tables
  • Good performance when processing lots of data in batch
  • Easy to learn and use

Cons

  • The client is quite heavy in terms of size and function
  • Better way to upgrade
  • Test and deployment automation needs to be improved
  • Low coding
  • High performance
  • Cross teams for different purpose
Much easier to learn and better performance
DB level or flat file for reporting or analysis

Informatica PowerCenter (legacy) Feature Ratings

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

Comments

More Reviews of Informatica PowerCenter (legacy)