Old yet powerful ETL Tool
May 31, 2021

Old yet powerful ETL Tool

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

Overall Satisfaction with Informatica PowerCenter

We used Informatica PowerCenter as an ETL to to feed data into Teradata Data Warehouse that houses all data marts of our company.
Mainly used to process semi-structured and unstructured data like web and mobile logs. It has been well tested against large volume of data and it stood up to the expectations.

Pros

  • Informatica Powercenter is an innovative software that works with ETL-type data integration. Connectivity to almost all the database systems.
  • Great documentation and customer support.
  • It has a various solution to address data quality issues. data masking, data virtualization. It has various supporting tools or MDM, IDQ, Analyst, BigData which can be used to analyze data and correct it.

Cons

  • It doesn't have much scheduling options and the tool is not very much capable if we schedule more jobs.
  • Debugging the workflows and mappings are very hard with Informatica PowerCenter.
  • Lookup transformation on large tables consumes more Memory and CPU.
  • Flexible and stability when transforming large amount of data.
  • Better and robust integration with cloud data warehouse.
  • We recognized the large project scope and had all stakeholders involved when on-boarding this solution. We had data transformation diagram ready before the implementation work which saved us a tons of potential rework.
Informatica PowerCenter is highly flexible and scalable for different types of data and it has any inbuilt function to transform our data into the meta data structure. Some of the tool sets such as TDM, is good in some ways but need EBF more than often when running into any issue.

Do you think Informatica PowerCenter delivers good value for the price?

Yes

Are you happy with Informatica PowerCenter's feature set?

Yes

Did Informatica PowerCenter live up to sales and marketing promises?

Yes

Did implementation of Informatica PowerCenter go as expected?

Yes

Would you buy Informatica PowerCenter again?

Yes

Informatica Powercenter is the centerpiece of our overall enterprise data warehouse strategy. It's a critical enablement to ensure we can feed in multiple data stream and transform them into digestible data within our data warehouse. With its flexible capabilities and API availability, we were able to feed in industry standard data format as well as home grown data structure. Overall, we are very pleased with their capability and contribution to our data warehouse strategy.

Informatica PowerCenter Feature Ratings

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

Comments

More Reviews of Informatica PowerCenter

  1. Home
  2. Data Integration Tools
  3. Informatica PowerCenter Reviews
  4. User Review of Informatica PowerCenter