Informatica PowerCenter Reviews & Product Details - Page 4

I am new to ETL development. Learned on Informatica Powercenter. Great resources on transformations. Able to visualize data flows nicely. Review collected by and hosted on G2.com.

I find it a bit tedious to move between ifnormatica designer, informatica worklow manager and informatica monitor. As well as set up target tables, I would like to have built directly in designer rather than create a table and then link as target source. Review collected by and hosted on G2.com.

Widespread documentation. Industry choice. Customer support Review collected by and hosted on G2.com.

The user interface feels old. There is no "undo" functionality for the designer Review collected by and hosted on G2.com.

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.

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.

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.

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.

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.

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.

A very easy debugging method and easy to use as well. Review collected by and hosted on G2.com.

The licensing cost for Informatica is very high. Review collected by and hosted on G2.com.

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.

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.

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.

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.

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.

No Looping Constructs are not present in Informatica.

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

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.

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.