PowerCenter

bon outil complet

Commentaires : J'utilise Informatica PowerCenter comme ETL pour fournir des données à l'entrepôt de données Teradata qui héberge les informations client de la compagnie d'assurance.

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.

Good ETL tool

Commentaires : I was using Informatica PowerCenter as an ETL to to feed data into Teradata datawarehouse that houses customer information for an insurance company.

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.

Good but require to inbuilt multiple function

Commentaires : It's good but yeah not too good

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

POWERCENTER: The old legacy to be avoided

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.

Ease to use

Commentaires : Ease to work

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.