Informatica PowerCenter Reviews & Product Details

Informatica PowerCenter Overview

What is Informatica PowerCenter?

Informatica PowerCenter® helps you unleash the value of your data. It offers a unique end-to-end data integration platform, with a broad set of capabilities to integrate raw, fragmented data from disparate sources, transforming it into complete, high-quality, business-ready information. As your environment grows and matures, PowerCenter scales to meet your expanding business needs, data volumes, and complexity, while providing insights to IT and the business

Informatica PowerCenter Details
Product Description

Power Data Integration Tool


Seller Details
Seller
Informatica
Company Website
Phone
650-385-5000
Year Founded
1993
HQ Location
Redwood City, CA
Total Revenue (USD mm)
$1,047
Twitter
@Informatica
109,693 Twitter followers
LinkedIn® Page
www.linkedin.com
4,878 employees on LinkedIn®
Description

Organizations around the world rely on Informatica to realize their information potential and drive top business imperatives. Worldwide, over 5,000 enterprises depend on Informatica to fully leverage their information assets from devices to mobile to social to big data residing on-premise, in the Cloud and across social networks.

Show More

Informatica PowerCenter Screenshots

Informatica PowerCenter Reviews

Write a Review
Filter reviews
LinkedIn®
Connections
Popular Mentions
Showing 54 PowerCenter reviews
Popular Mentions
Showing 54 reviews
Filter Reviews
Filter Reviews
Sort by
Ratings
Company Size
User Role
For Category
All Industries
Region
Already have Informatica PowerCenter?
Write a Review
Data Engineer
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
What do you like best?

Informatica Powercenter is an innovative software that works with ETL-type data integration, this powerful tool facilitates data migration and the integration of different databases such as SQL Server and Oracle, all this under one interface intuitive and simple to implement, its support system is very efficient and solves errors that occur in a matter of minutes. Review collected by and hosted on G2.com.

What do you dislike?

The implementation costs are high and it is probably difficult to acquire for smaller companies, it would be good if the prices are adapted to the needs of the users, besides to when I want to get more functions I have to pay more money which seems to me a negative aspect, I can also say that I dislike it when it slows down, this happens mostly when I try to process a large amount of data. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

If you are looking for software that integrates data in real time, do not hesitate to use Powercenter computing, its multiple functions and characteristics make you choose it over other software that provide similar services. It should be noted that this software provides sustainability for various data integration projects, making it one of the best options available. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Since we began to implement this tool in the company, it has significantly improved the workflow, since the data migration is carried out efficiently and precisely, it has also helped the integration of data from different places coalesce appropriately. Review collected by and hosted on G2.com.

Show More
Show Less
UB
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

I really loved the Extracting, transforming and loading data to and from different databases. Large amount of data can be processed without any hassle. The User Interface is quiet easy and simple to use. It also provides variety of transformation options to manipulate the data. It also supports processing of real-time data. Review collected by and hosted on G2.com.

What do you dislike?

It is hard to handle BLOB and CLOB data types. Also, deployment is bit complex. Memory utilization of this tool could be improved to some extent. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

If you have to deal with large amount of data then go for it. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Large amount of data can be processed very easily and rapidly which saves considerable amount of time. Also it can be integrated with different data sources which makes the usage of this tool quite simple. Review collected by and hosted on G2.com.

Show More
Show Less
UB
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Informatica Powercenter is widely used as an ETL tool in various big and medium size projects. It can connect to various types of sources like Databases, Flat File, CSV, Excel, XML etc. It has a various solution to address data quality issues. data masking, data virtualization. It has various supporting tools or MDM, IDQ, Analyst, bigdata which can be used to analyze data and correct it. This is also one of the popular tool for Data Migration project. Review collected by and hosted on G2.com.

What do you dislike?

Maintenance and version upgrade of tool takes lot of effort. Also, this is not available with a Cloud service provider as SAAS service. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Connecting with multiple source, Harmonizing the data and Data warehousing purpose we use this. Review collected by and hosted on G2.com.

Show More
Show Less
Campus Ambassador
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

The tool is very user friendly. The best thing is when you work on it and try to save a mapping or something you can easily check whether the process is correct up to that step or not and according to that you can proceed further. Review collected by and hosted on G2.com.

What do you dislike?

The visualization might be improved, I mean the interface of that software. They can work on the visualization part to make it more user friendly. One more aspect I want to include that when I work on it sometimes data might be lost for some time due to synchronization issues which may be resolved. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

It is a very potential tool for mapping and visualization of your data, you should consider it as it is a very powerful tool. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

It has helped me to establish a connection from a Unix server to a database server which was very required for my project. Review collected by and hosted on G2.com.

Show More
Show Less
Sr. Consultant | Enterprise Information Management (EIM)
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

It has lot of validation built in. It promots me if I missed something while creating mappings. Review collected by and hosted on G2.com.

What do you dislike?

I do think that few other transformation such as one for java are not that reliable and can not handle lot of data. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We are loading data to our EDW using Informatica. Review collected by and hosted on G2.com.

Show More
Show Less
Senior Mechanical Engineer
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

More user-friendly, you may find that you have good capacity in data bases to solve problems when using SQL in Source qualifiers and that good maintenance can be done by using a private access capability to your own creation, that allows you to load, manage and flow data from one source into the aim, which may also become a source for other table information. Review collected by and hosted on G2.com.

What do you dislike?

Further technologies for data transformation can be used, however, other transformations such as SCD, normalization for younger people are difficult to comprehend, python scripts support or networking support or publications should include. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Informatica PowerCenter has been one of the best data management devices over the years. The statistics it has produced have shown that this tool is the best tool in its use, its loyalty and its support. Since every company manages the humorous information every day, tools like Informatica have an important role to play to handle this data. Informatica PowerCentre is constructed on a structure such that data can be loaded from any source and loaded to target systems as required. This method allows some form of data integration to be accomplished. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

For about 3 years I've been working on this tool and the overall experience was good. Because it offers traditional capabilities and is easier to implement when you get the insight of it, this was a tool or set of tools for all ETL projects before the big data came. Review collected by and hosted on G2.com.

Show More
Show Less
Miss
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Informatica has tremendous GUI interfaces for Administration, ETL Design, Job Scheduling, Session monitoring and Debugging.

It offers Paralleh processing and Load balancing.

It follows the same process of ETL (Extract, Transfer Load ).

It consists of in-build concepts of data validation, data cleaning while extracting the data, transferring data by modifying as per the business requirement.

While loading data are assigned with dimensional keys to load on data warehouse or operational database. Review collected by and hosted on G2.com.

What do you dislike?

No Looping Constructs are not present in Informatica.

High cost is required in implementing new systems. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Informatica Powercenter is an amazing ETL tool. It has the capability to connect & fetch data from different heterogeneous source and processing and transforming of data. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

As a part of our work, we need to transform the transactional data and generate reports.

We extract data from its source, transform it as per business requirements and load it into a target data warehouse. Review collected by and hosted on G2.com.

Show More
Show Less
Marketing from Advertising
Marketing and Advertising
Small-Business(50 or fewer emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

An authentic program without a doubt, I love its ease of use. In addition to having a capacity to integrate with security systems that provide confidence. Another point in favor is that the types of data and its analysis handle it optimally. In other words, your system is incredible since I can extract data from the emission systems and modify them so that they fit into a destination system and then distribute the data later. In addition to being very fluid and with excellent search filters. Review collected by and hosted on G2.com.

What do you dislike?

One of the most notable failures is that the automation system has errors or functionalities. I still have time in my daily jobs not to have automated processes in some program specifications. In addition the use of memory is very high during its execution, therefore it is necessary to have an optimal equipment to use it. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

It has an incredible database level, this program can be cataloged as a powerful analyzer and report generator. It is ideal for migrating data between sources and with solid characteristics throughout the industry. Informatica Powercenter is in incredible conditions ahead of many of its competitors I dare to say. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We are using it for the purpose of generating flat files from different sources or loading data from systems previously given to us. It also serves as support for end users in various commercial departments. At data levels and report conclusions this tool is class A for us. Review collected by and hosted on G2.com.

Show More
Show Less
Senior Analyst
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

The parallel management and monitoring mechanisms of high volumes of data and number of workflows are very good. The tool has a wide range of transformers and connectors. Review collected by and hosted on G2.com.

What do you dislike?

If this method is to be used for unregulated excel outputs, the versatility offered by SAS / Python is not provided. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Use this tool not for small quick analyzes to crunch high volume data. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

ETL resource for company needs that is extremely mature. Has all the features you want in a high-duty data processor. Works with accuracy and reliability. Not as versatile as SAS / Python / R in excellent management Review collected by and hosted on G2.com.

Show More
Show Less
CI
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Organic
What do you like best?

Informatica power center the world's leader in ETL for more than 2 decades now ,provides world class functionalities for extracting the data from various sources and transforming the data using various transformation techniques and load the data to any of the target systems.

Informatica supports various source systems connections including all the leading data base systems, application systems, text files, cloud services etc.

It provides various different kinds of transformation techniques which helps transform the data in anyway the business expects.It has various transformations like source qualifier, lookup transformation, joiner transformation, normalizer, SQL transformation, TCL transformation,sorter transformations etc.

Additionally to these inbuilt transformation informatica also supports java transformation where user can write customized java code which helps to achieve the most difficult functionality.

Informatica also provides various connectors such as SAP connectors to connect to SAP applications/databases, Sales force connectors for connecting to Salesforce connectors and it provides the easy integeration with all the industry leading analytic tools which makes the implementation very easy. Review collected by and hosted on G2.com.

What do you dislike?

The tools bit complicated at starting as it contains 3 different four different components,

1. Informatica Workflow Manager

2.Informatica Monitor

3.Informatica Designer

4.Informatica Repository Manager.

Understanding the functionality of each of these above mentioned components is very difficult initially

Informatica requires good level of SQL skills to write various queries to fetch the data from any source systems. This is required in order to fetch data with exact filter so that the unwanted data can be filtered out.

Additionally it also requires good amount of knowledge on shell scripting as there will very high chances that the files should Sent via FTP or SFTP to other servers if the target system is file. This implementation requires knowing the shell scripting. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

As over the years Informatica is one of the best Data Integration tool. The statistics it has generated has proven that this tools in terms of usage,loyalty, support is one of the best tool.Since Every company produces humongous data everyday and to handle this data in anyway the business want to see, Tools like Informatica plays an important role.

Informatica is built on such an architecture that it can load data from any source and transform it the way it is required and load it to the target systems.

So using this tool one can achieve any sort of data integration. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

1. Extract Data from various sources such as SAS DETs, SAP Systems, Oracle DBs, Green plumb Data lakes, Flat files, Salesforce systems, Microsoft SQL DB's and implement various transformations and transform the raw data into business useable data and load the data into various Data marts.

2.Create various Informatica jobs based business requirements, schedule the jobs based the requirement.

3. Refresh the reports daily after the jobs are completed.

4. Check the data quality and data quantity each day before loading the data into various data marts.

5. Fix the various data issues working with the client team and business stake holders.

6. SFTP the file generated each day to different servers for further processing.

6. Do the performance tuning of the jobs if they take much time while running.

7. Use third party tools to schedule the jobs when we need to run the jobs on irrelevant timings. Review collected by and hosted on G2.com.

Show More
Show Less
CA
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Organic
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

Ease of working and easy to learn, package comes in 4 parts, Repository manager, Mapping Designer, Workflow Manager, Workflow Monitor. All are easy to work on. Best part is the leaning guide that you can open simply clicking on help button Review collected by and hosted on G2.com.

What do you dislike?

The only thing that comes into dislike is performance issues, Can't handle huge amount of data. Application got struck while processing large amount of data. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Easily implemented difficult reporting logic using Powercenter. Review collected by and hosted on G2.com.

Show More
Show Less
UI
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Ease of use and connectivity with different databases .It has reduced a lot of legacy coding which we need to write manually. It is very easy and simple to use to the end user. Review collected by and hosted on G2.com.

What do you dislike?

The only thing user will face difficulty is the intial set up. It is not as easy as using it after installation. One professional is necessary to start with the set up of this product. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

It depends on the size of the organization and the size of data they are trying to do integrate. For a company which is affordable of this product I can say go for it.Totally,I can give 10 out of 10 rating for this product. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We used to use this tool for data integration. It has everything that what we were looking for earlier.The scalability and stability of this product is very impressive. Review collected by and hosted on G2.com.

Show More
Show Less
AE
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from the seller
What do you like best?

- It is one of the most powerful and user friendly ETL(Extraction, Transformation and Loading) tool.

- Very easy to use - drag and drop

- integration with other applications is easy.

- Good tool to manage legacy data and to make compatible with modern applications.

- Good team of community members and support analysts make it very helpful to debug any issues Review collected by and hosted on G2.com.

What do you dislike?

- the licensing is very expensive But it is manageable, it's value for money.

- Every time we need to pay extra amount if we want any extra plugin for other applications to be activated. Sometimes it appears very slow in data processing Review collected by and hosted on G2.com.

Recommendations to others considering the product:

- i highly recommend this ETL tool over other tools but only if you could afford for it

- they have plugins to integrate with most of the applications out there Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

- to accomplish the ETL process from different sources

- availability of plugins (integrators, service providers, etc.) to connect to different applications

- to make deployments seemless Review collected by and hosted on G2.com.

Show More
Show Less
AA
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
What do you like best?

It has been very reliable. We have had very little downtime in our production environment because the platform is so stable. Review collected by and hosted on G2.com.

What do you dislike?

We dislike having to install thick client software in order to view running workflows and design them. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We are able to transfer data between our Oracle and Microsoft databases easily. Review collected by and hosted on G2.com.

Show More
Show Less
Senior Software Engineer
Information Technology and Services
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Organic
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

A powerful tool which can be used to integrate/access various data sources.

Supports various data sources like Relational Sources, FlatFile, XML etc. Review collected by and hosted on G2.com.

What do you dislike?

Have to pay very huge money to buy this software.

Need to pay additional amount if i want to get any additional plugins. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Definitely recommend this product to other customers. But considering the price, I feel it bit more expansive than other software. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We are using Informatica to integrate various sources.

Loading data very easily. A powerful tool used to extracts tons of data. Review collected by and hosted on G2.com.

Show More
Show Less
CI
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Easy of learning and understanding for new person Review collected by and hosted on G2.com.

What do you dislike?

Adaptability to cloud and big data is slow Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Data Migration, Data Integration Review collected by and hosted on G2.com.

Show More
Show Less
Mobile Application Developer
Information Technology and Services
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

various tools in it, which makes workflow development easy. Review collected by and hosted on G2.com.

What do you dislike?

If the PC configuration is not good, then it lags a lot Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Used it to solve the data sparse over different databases and accumulated it in one database using different transformations. It helped in building reports on top of centralized data. Review collected by and hosted on G2.com.

Show More
Show Less
UI
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

Informatica Powercenter provides the real time data integration services

Its highly intuitive and customizable that speeds up the development process

It comes with full suit of data management components including data integration, data quality, data governance etc

Seamless integration with informatica MDM and data masking tools Review collected by and hosted on G2.com.

What do you dislike?

Its a bit costly compared to other cheaper alternatives Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Its a great tool, definitely recommended Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Data Integration Review collected by and hosted on G2.com.

Show More
Show Less
Business Consultant, Bengal Solutions
Higher Education
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

I mostly like working with the informatica designer as it is very easy to get source and targets by connecting to the server. There are variety of transformations available to clean the data and you just have to find the right one. Review collected by and hosted on G2.com.

What do you dislike?

Sometime when I run the workflow and if there are some errors, especially those associated with date time conversion, informatica does not tell you why actually the error occurred. You have to go to the session log and google the error to find more about how to solve it. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

If you are considering using a different database management system, such as moving from legacy systems or mainframe to modern RDBMS, you definitely need informatica. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Mostly I use informatica for data migration from DB2 to MSL Server. Since the new system queries the SQL Server, using informatica has helped us achieve that goal. Review collected by and hosted on G2.com.

Show More
Show Less
UI
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Organic
What do you like best?

One of major reason for Informatica etl tool success is its capability of enabling Integration. Informatica also leverage the same integration model. Easy training and tool availability has made easy resource availability for software industry, where else other etl tools are way behind in this aspect. Informatica comes with internal scheduler unlike many other etl tools where one need to use third party scheduler. Review collected by and hosted on G2.com.

What do you dislike?

Transaction rework costs. Cost incurred in implementing new systems.Delays In delivery data to decision maker which has lost many customers due to poor service. It allows to use Persistent cache, which gives you performance boost by saving time in building the lookup while session run but it still takes the same time like a normal lookup for using the lookup data during session runtime. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Yes, definitely go ahead to learn more and more of informatica tool. If planning to play with data, then definitely this is the platform to begin. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

The productivity of the environment. We get more done faster and more repeatably. The Data Profiling tool now has been enhanced with really nice data visualization capabilities to make it far easier and faster to understand your data and it’s relationships. Another addition is 100 free Analyst Tool seats to all editions of PowerCenter. Informatica has been driving agile data integration development based on the idea of a development team made up of a developer and a business analyst. Review collected by and hosted on G2.com.

Show More
Show Less
UI
Enterprise(> 1000 emp.)
Validated Reviewer
Verified Current User
Review source: Invitation from G2
What do you like best?

Excellent feature-functionality Good performance Ability to handle large data sets Sizeable talent pool Expensive licencing Poor integration with external source control, testing and release management tools Limited & clumsy handling of EDI (X12) data sets.

The software features role-based tools that support iterative business collaboration and development. Data integration is governed by metadata and the highly efficient ETL engine of the software. Other important features offered by the software include rapid prototyping, instant data profiling, graphical data flows, impact analysis, automated data validation, and efficient distributed processing. Review collected by and hosted on G2.com.

What do you dislike?

Management features of Informatica PowerCenter do not include metadata management. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

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.Informatica provides all the functions indexed in a proper fashion in expressions editor with syntax to allow users to build logic with ease. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

we are very satisafied with Informatica on-Premise powercenter solution. However, we experienced issues with Informatica BDM solution. Informatica did not have enough expertise in handling some of the issues. It had to go to R&D to get fixes. Review collected by and hosted on G2.com.

Show More
Show Less
UI
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from the seller
What do you like best?

Easy to use and flexible professional and lots of options and compatibility Review collected by and hosted on G2.com.

What do you dislike?

sometimes its a bit complex with database drivers Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

its used to load the data ETL , it will handle large amount of data from multiple sources Review collected by and hosted on G2.com.

Show More
Show Less
Software Engineer
Information Technology and Services
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Informatica is a Best ETL tool,User freindly and selef descriptive.

we have different kind of transformation which helps us to Load the data in desired format. Review collected by and hosted on G2.com.

What do you dislike?

Informatica having so many sub tools like designer,workflow designer and monitor Review collected by and hosted on G2.com.

Recommendations to others considering the product:

It is best ET tool to work on ,tool is contains all transformation to cleans and lload the data Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Informatica helps us to cleanse the data which are coming from different sources like flat file,database etc. Review collected by and hosted on G2.com.

Show More
Show Less
CI
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Tool is very user friendly and you have very flexible features.

each and every component or transformation is so deltailed that you can use it easily and help content is so detailed that eit will explain each and every step.

scheduling the jobs are very easy and you can rely on sceduling jobs.

informatica is a repository bases so each and every transaction is saved. Review collected by and hosted on G2.com.

What do you dislike?

This run one job many components needs to be created like mapping session and worflow Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Informatica power center is a best tool,you start loving it when you start using it Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

DAta transmisssion from dource system to warehouse Review collected by and hosted on G2.com.

Show More
Show Less
UC
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Organic
What do you like best?

It is easy to use and probably the best ETL tool I have worked on. It is very convenient to create reusable and non reusable task depending on the user needs. Review collected by and hosted on G2.com.

What do you dislike?

There are few bugs in the tool which can be fixed. It is slow in sometimes. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

If the source data is huge then Informatica is preferable to use as it is unnecessary to purchase if your company has small data when we compare with pricing for relative ETL tools. You can get the visual pictures of metadata, data flow and throughput within no time. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We use it as ETL tool. It helps in cleansing the source data very easily and load into target table. To remove unnecessary data in source data so that process can be fastened. Review collected by and hosted on G2.com.

Show More
Show Less
Do you work for PowerCenter?