PowerCenter

Avantages

Pour les utilisateurs qui souhaitent développer un entrepôt de données mais qui n'ont pas beaucoup d'expérience en programmation, Informatica PowerCenter est un bon outil ETL. Il a une belle interface où les utilisateurs peuvent glisser-déposer pour créer des flux de données. C'est très intuitif et convivial.

Inconvénients

PowerCenter est un logiciel lourd et l'installation n'est pas facile. Il utilise beaucoup de mémoire, et s'il n'y a pas assez de ressources, il peut planter le système.

Avantages

The ETL by Informatica is beautiful. The Infortica ETL process makes the job of a DBA / DBM very easy.

Inconvénients

Well, I cannot remember any cons. Power Center is very good. Informatica did an awesome job.

Avantages

1. Drag and drop services
2. Easily maintain
3. Run multiple batch jobs
4. Define methods with logistics

Inconvénients

1. Can't schedule in workflow
2. Job running status logs are too long
3. Doesn't have parallel off functionality
4. Can't be sync with repository automatically

Avantages

If you are a PowerCenter expert you can do almost any data transformation.

Inconvénients

It is very complex and difficult to use. Super expensive and with minimal suport.

Avantages

multiple tools available for development, support and troubleshoot - workflow monitor, workflow manager, workflow designer, repository manager, etc.

Inconvénients

it's not an easy job to track back from target to source

Avantages

1. Able to process a huge record size. In the latest project, we used Informatica to load approx 5 Million records daily. There were no performance issues due to the data size.
2. . PowerCenter has very easy to use drag and drop interface which can be used in integration with other applications.
3. Good tool to manage legacy data and to make compatible with modern applications.
4. PowerCenter also has other additional features like the ability to profile data, visualize graphical data flow etc. Data validation can also be done very easily using the validation feature.

Inconvénients

There is a huge licensing fee which is worth it as the product is one of the best ETL tools, but projects which smaller budget find it challenging to justify the cost.

Avantages

The ease of development, debugging, migrating and maintaining the code.
Heavy duty performer and can scale to perform multi-threading.

Inconvénients

It does not have strong ELT features or market - so cannot leverage the high computing capability.
Still based out of legacy ETL process which needs to be migrated.

Avantages

Informatica PowerCenter is a user friendly tool.

Inconvénients

The price of Informatica PowerCenter tool is a bit high

Avantages

Informatica PowerCenter is a good ETL tool for users who wish to develop a datawarehouse but do not have much programming experience. It has a nice interface where the user can simply drag and drop to create a data flow. It is very intuitive and user friendly.

Inconvénients

PowerCenter is a heavy software and installation is not a trivial task. It uses a lot of memory and it could crash the system if it does not have enough resources.

Avantages

The best thing about informatica power center is that we can use it with multiple source types.

Inconvénients

I guess the GUI can be improved as it is less user friendly or you can say boring.

Avantages

Drag and drop function is easy for the developers and users to complete development faster.

Powerful out of box functions are added advantage.

Inconvénients

Initially the licensing was a bit expensive however with competition from market helped make competitively priced.

Avantages

It Works vwell with large structured data files PowerCenter processes input files, performs specified transformations, and maps the input data format to the output data format very quickly. The PowerCenter backend implementation seems to be optimized to process and map structured input records to structured output records and load the records into a database. One of the strengths of PowerCenter is performance of processing petabytes of structured input data files.
PowerCenter does not require a software development experience or education. After providing initial hands-on training, the data consultants (who are statisticians, subject matter experts) in our organization were able to implement data ingest and data transformation tasks fairly easily.
PowerCenter supports multiple DBMS technologies (for example, Oracle, Netezza). This flexibility allows it to be used by multiple departments within AT&T organization.

Inconvénients

PowerCenter processes input files, performs specified transformations, and maps the input data format to the output data format very quickly. The PowerCenter backend implementation seems to be optimized to process and map structured input records to structured output records and load the records into a database. One of the strengths of PowerCenter is performance of processing petabytes of structured input data files.
PowerCenter does not require a software development experience or education. After providing initial hands-on training, the data consultants (who are statisticians, subject matter experts) in our organization were able to implement data ingest and data transformation tasks fairly easily.
PowerCenter supports multiple DBMS technologies (for example, Oracle, Netezza). This flexibility allows it to be used by multiple departments within our organization.

Avantages

PowerCenter is being used across the organization for all our ETL needs weather to load data from different sources, collect data from different flat file or integrate multiple systems for reporting requirement.

This is the best and easiest tool for pulling data from source systems, modifying it and load to target system.

It also provide the best performance when processing huge data in batch

PowerCenter supports various DBMS technologies for e.g: Oracle, Netezza. This flexible nature of it allows it to be used by multiple departments.

And last but not ;least it is very easy to learn and use

Inconvénients

There is no or less password encapsulation in this software rest everything is great.

Avantages

When joining Informatica I have to say, the whole process was a very nice and comforting transition. I was very impressed by level of care, focus and how they approached the recruitment process.
The Human resources and Management team are a really great bunch of people and I believe we made the right choice together. They gave me confidence in how the company is run, they were clear and concise on how the company structure works and what the expectations are.
The company progression is great, already I'm gaining more responsibility and growing and learning more about the industry, so on this I would certainly recommend Informatica as a prospect to anyone looking for an Innovative, Positive, growing and fun company to work for

Inconvénients

Scheduler tools can manage dependencies
accross many systems and environments. For instance you can
configure it so that your informatica job only runs after the
successful completion of some other system's windows job and/or
another system's batch job.

Avantages

Great support and knowledge base. Easy to learn

Inconvénients

Currently the managing of EII processes (like Restful or SOAP) are not well supported by the on-premise solution.

Avantages

Easy to integrate with any DB, flat file. Core concepts are very similar to sql. Very easy to understand the flow of data from source to target.

Inconvénients

No auto refresh functionality. Lack of a
Script to automatically generate the parameter file.

Avantages

Easy to Learn
Multiple connectors for data transfer
Handles multiple data sources
IDQ and Informatica MDM were real game changer compared to other ETL tools

Inconvénients

Not so compatible with upcoming technologies for Big Data and Data Science.
Informatica cloud needs to be marketed more and made compatible like Powecenter

Avantages

It allows you to integrate multiple datasets from different sources.

Inconvénients

What I like the least about this software is the costs of the licensing.

Avantages

One of the Important pro is that GUI interface is very easy to use and understand. I have used other ETL tool like SSIS but Informatica PowerCenter helps developing ETL is easiest way.
Transformation works great and efficiently.

Inconvénients

When compared with SSIS, informatica PowerCenter doesn't perform well when source and/or target database is SQL Server. However that is understood because SSIS and SQL Server both are native to Microsoft.
Sometimes the buffer space gets filled quickly even if lookup query doesn't seem to be heavy.
Just as a suggestion - It would have been great if there was a inbuilt performance tuning tool that could suggest way to improve mapping performance.

Avantages

Powercenter by Informatica is a strong ETL tool which has all the features and functionality making it the best choice for your data warehouse needs. The GUI interface makes designing a mapping super-easy. The tool contains various transformation that can be used to translate your business needs

Inconvénients

There is no actual CONS that I have seen with tool. Have been using it for so many years and I am completely happy with it.

Avantages

It's level details about the issue and various tool for each activities

Inconvénients

We require a better system configuration to support the software there is no lighter version of it

Avantages

This tool has so many functionalities and options to use for data flow and transformations

Inconvénients

Didn't meet my expectations when tried to use it along with other Cloud AWS services

Avantages

It can connect to almost all types for sources and targets, it has so many built in transformations which can be readily used to meet the business needs.

Inconvénients

Its performance when dealing with huge volume of data is not that great when compared to Ab-initio. Also, its very expensive.

Avantages

Transformation of data by Any kind of e trance (from csv filés, txt, from bank tables).

Inconvénients

The Source Qualifier filters and debugger Mode.

Avantages

It helps with our ETL process, and allows us to successfully build and schedule complicated workflows.

Inconvénients

The price. This software does a lot of great things, but we pay way too much for this service yearly.