PowerCenter for ETL
- 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.
Cons
- 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.
- 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