What is Informatica PowerCenter?

Enterprise data integration platform to help organizations access, transform, and integrate data from a variety of systems.
Also known as
PowerCenter
Sample customers
State of Washington

Informatica PowerCenter Reviews

4.1 out of 5 stars
 (4)
Data integration report from it central station 2017 07 01 thumbnail
Find out what your peers are saying about Oracle, Informatica, Microsoft and others in Data Integration Tools.
217,939 professionals have used our research on 5,608 solutions.
Data integration report from it central station 2017 07 01 thumbnail
Find out what your peers are saying about Oracle, Informatica, Microsoft and others in Data Integration Tools.
217,939 professionals have used our research on 5,608 solutions.

User Assessments By Topic About Informatica PowerCenter

* Able to access heterogeneous databases: It can work with any kind of database available in the market. In fact, it can be applied to NoSQL databases as well. * SQL override allows users to write simple to complex queries inside mapping for performance tuning the load process, pre and post SQL can help control the load process to get desired outputs. * Error handling techniques: Informatica provide a suite of options to handle errors. From logging error in database tables to e-mail notifications with log files, to decision/assignment tasks for data control, it can handle error at every stage of workflow. Restart options for batched work-flows. * Debugging, is one other feature I found extremely useful. Before running a full load, you can run a subset of data from source-target and check for values generated from logic at every transformation. * While in debugger mode Target tables do not load any physical data. The best part of debugging in Informatica is that, in the debugger mode, you can alter logic in expression transformation and check for the value generated from the logic. This will allow you to change logic if it's needed later. * Transformations - the types of transformations (SQL Logics) provided are unmatched to any other ETL tool out there. When it comes to using transformations, even a beginner can understand with minimal effort, how to use them or what the expected output will be using that particular transformation. Most of them are self-explanatory, and provide the desired output. Especially Expression Transformation (which is the heart of any mapping). * Can be used to build any type of logic with flexibility giving the number of logical functions (date/time/string etc...). Functions have a syntax that is very easy to understand. * Informatica provides all the functions indexed in a proper fashion in expressions editor with syntax to allow users to build logic with ease. * Version control, as check-in and check-out are easy and allow space for adding comments. These comments can come in handy during deployment when writing queries.
Products most compared with Informatica PowerCenter
Read reviews of Informatica PowerCenter competitors and alternatives from the IT Central Station community.
Informatica... is compared to  % of the time.
Stats based on 56,734 user comparisons.Compare products »

Informatica PowerCenter Questions

Ddp 8148
Ariel Lindenfeld
Community Mgr
Sr. Director of Community
IT Central Station
Anonymous avatar x30
reviewer99681Some thoughts about SSIS vs. Informatica Informatica vs SSIS Security... more »
Picture 1288 1365323206
GaryMTwo things 1) we already had this discussion on a LinkedIn group if you can... more »
0 0nzjktdfc 7mm   ocv1zpo rtr2vty o56knpcd4zl7j82yyqjaqmth0wu?1414330334
Paula DiTalloLike anything ETL related, it really depends on what your overall goals are... more »

Informatica PowerCenter Projects By Members

Check out these projects from our community members.
Big data
Master data management for around 60 source
Master data mangement for around 60 sources in 6 months 1. Different Variety of Data  Property , Retail , Malls... more»
Big data
Architected and implemented a large Performance Reporting solution
Architected and implemented a large Performance Reporting financial solution

Informatica PowerCenter Consultants


Request a call with one of our top consultants and experts in Informatica PowerCenter. (Add me to this list.)
0c9bce29 fb0a 4f7e a93d be896202f2cc avatar
496
Technology Architect
Expertise in designing & developing solutions in Greenplum which is a distributed and massively parallel processing (MPP) database engine. Expertise in performance tuning Greenplum design for extracting best performance leveraging MPP capabilities. Expertise in data modelling (Conceptual,... more>>
Reviewer108354 li?1414332543
653

2
TOP 20
Manager of Data Analytics
Reviewed Informatica PowerCenter: Costly yet Effective & Efficient tool for...

Sign Up with Email