Amazing ETL Tool
December 01, 2020
Amazing ETL Tool
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Informatica PowerCenter
Informatica PowerCenter is widely used as an integration tool across many projects. This is being used in specific departments. It lets us connect to endless sources in order to pipe data out into different available repositories. Primarily it feeds our various data warehouse and data marts. Also this is being used in Salesforce implementation project to transfer data from Flat files and Relational databases to Salesforce Objects.
- Extracting, transforming and loading data to and from different databases.
- Development, testing and maintenance of code is fairly simple.
- Good performance even during processing of large amount of data.
- Amazing ability to connect with different types of sources and targets available in the market.
- Performance with ODBC drivers is comparatively slow which ends up in taking a lot of time.
- Deployment is bit complex.
- Clobs and Blobs datatypes are very difficult to handle.
- Reduced time for transforming data.
- Multiple projects are being handled.
- Availability of easy resources in the market to employee.
This is great tool to handle large data in multiple data sources.
Do you think Informatica PowerCenter delivers good value for the price?
Yes
Are you happy with Informatica PowerCenter's feature set?
Yes
Did Informatica PowerCenter live up to sales and marketing promises?
Yes
Did implementation of Informatica PowerCenter go as expected?
Yes
Would you buy Informatica PowerCenter again?
Yes