Informatica PowerCenter Review
As ETL tools in general, it does not include a good data reporting feature.
What is most valuable?
- The possibility to create a data profiling mapping automatically from any imported source.
- The client installation includes a macro that can be imported into Excel. This will contains standard documents for technical design and documentation in general. The technical design developed in Excel can be directly imported into Powercenter using Powercenter Repository Manager and the corresponding mapping is automatically created. This can save a lot of development time for simple or not very complex mappings. This feature is called Mapping Analyst for Excel.
- The default error handling, automatically created, is quite good for those architectures that don't have a proper one or a budget for a custom one.
What needs improvement?
As all ETL tools in general, it does not include a good data reporting feature.
Another one is the component called "Union" which includes some bugs:
- Adding new groups, the field-names are lost
- Adding new fields, the field type should be reset for all fields in the "Union" or the mapping validation will fail.
There is no possibility of handle non matching records in a "joiner" as in DataStage.
For how long have I used the solution?
4-5 years, different versions.
What was my experience with deployment of the solution?
What do I think about the stability of the solution?
What do I think about the scalability of the solution?
Which solution did I use previously and why did I switch?
I used other tools like IBM DataStage. The final decision is made by my clients but what I see is that clients using DB2 prefer to use DataStage over Informatica as both (DB2 and DataStage) are IBM products.
How was the initial setup?
What about the implementation team?
**Disclosure: I am a real user, and this review is based on my own experience and opinions.
Last updated: Sep 17 2014
More Informatica PowerCenter reviews from users
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: January 2021.
454,950 professionals have used our research since 2012.