Integrates well and assists with ETL transformation tasks
What is our primary use case?
Our primary use case for this solution is at a Russian bank.
The goal was to integrate DWH with a banking core system that used Pervasive SQL 2000 DB. The bank as our client in the field of Data Warehousing asked us to extract data from their core banking system and build a Data Mart for preparation of regulatory reports.
How has it helped my organization?
Informatica PowerCenter moved forward the technology level of ETL-process management of the bank with visualization and standardization of ETL development instead of a huge volume of scripting used previously. Moreover, the task of integration of systems based on different technology platforms was successfully solved.
What is most valuable?
The most complex task, in this case, was to read and transform BLOB data, and Java transformation in Informatica Power Center was a great solution. The second task that was solved with Java transformation was the correct transformation of the Amount field (each amount in PSQL 2000 is stored in three different fields). These tasks were solved by using PSQL 2000 Java SDK library imported to Informatica PowerCenterJava Transformation.
What needs improvement?
I hope that the next release of this solution will:
- Work with HADOOP and other BigData solutions.
- Have an ability to compile code to run it quicker.
- Include new features for parallel job execution.
- Include more instruments for LOGs analysis, interpretation, and job corrections.
For how long have I used the solution?
I have been using this solution for more than a year.
What do I think about the stability of the solution?
It works stably but needs a dedicated professional admin in the project team.
What do I think about the scalability of the solution?
It's scalable and can be supplemented by a Data Quality solution.
How are customer service and technical support?
We used the vendor's distant support and the expertise was excellent.
If you previously used a different solution, which one did you use and why did you switch?
As we are a consulting and data management company, the instruments we have to use during the project are chosen by our customers.
How was the initial setup?
The initial setup of this solution was straightforward.
What about the implementation team?
We implemented this solution at the customer's site as consultants.
Which other solutions did I evaluate?
We are also using IBM DataStage, Oracle Data Integrator, SAP Data Services. From project to project it's up to the customer.
Disclosure: I am a real user, and this review is based on my own experience and opinions.