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.

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.

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.

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.

It works stably but needs a dedicated professional admin in the project team.

It's scalable and can be supplemented by a  Data Quality solution.

We used the vendor's distant support and the expertise was excellent.

As we are a consulting and data management company, the instruments we have to use during the project are chosen by our customers.

The initial setup of this solution was straightforward.

We implemented this solution at the customer's site as consultants. 

We are also using IBM DataStage, Oracle Data Integrator, SAP Data Services. From project to project it's up to the customer.