Overall Satisfaction with PowerCenter
Our firm provides consultancy to several federal government clients. Currently we are using Informatica Powercenter for aDHS - USCIS client to perform ETL on daily basis (both initial full load and incremental load) into various data marts. It helps in moving data from one source to another, mainly to a data warehouse to help generate reports.
- Data migration from multiple sources. It handles any type of source data including RDBMS, flat files, XML, mainframe etc.
- Implementing data migration rules is very easy and efficient and reusable.
- Development and maintenance of code is very easy. Design, development and scheduling of full load and incremental load is very easy.
- Provides lot of features for developers to implement any kind of business rules.
- Not worth doing simple data migration using powercenter.
- Licensing cost.
- Handling Blobs and clobs data types.
- It has a high ROI.
- Overall very happy with the product.
- Very useful in fulfilling business needs.
- Data stage, PLSQL and Oracle Data Integrator
- Powercenter provides lots of features to implement mapping rules.
- Very easy to design, develop and maintain ETL code.
- Easily integrate with its other products like IDQ and MDM.
Informatica PowerCenter Feature Ratings
Using PowerCenter
12 - Information technology - consultancy
10 - ETL developers with Powercenter, SQL development experience
- Data migration
- Full Load and incremental load
- Data warehouse development
- Implement complex data migration/business rules
- Clean up data
- Standardize data
- Data Quality
- Data profiling
- Address Validation