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?