Integration with Informatica
April 02, 2014
Integration with Informatica
Score 9 out of 10
Vetted Review
Verified User
Software Version
9.5.1
Overall Satisfaction with Informatica Enterprise Data Integration
Informatica is used to integrate to various applications like SAP, Salesforce etc. with Oracle and SQL databases. It's used by various departments across the Americas. It helps to optimize the data for various reporting tools.
- Tracking Changes in slowly changing dimensions
- Fact & multi-dimensional loading
- Integration of data from SAP and Salesforce is better with this ETL tool compared to other tools in the market
- Modularity
- Several partnerships diminishing the value of technologies
- Unable to get list of objects from Repository (like sources & targets) that don't have any dependency
- Scheduling: The built-in scheduling tool has many constraints such as handling Unix/VB scripts etc. Most enterprises use third party tools for this.
- Master data management
- Data lineage and data archiving
- Data discovery and profiling
- Increased reporting strategy
Ab Initio, SSIS, Cognos