Informatica - Review at a glance
March 20, 2014
Informatica - Review at a glance
Score 9 out of 10
Vetted Review
Verified User
Software Version
9.6
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.
- Integration of data from SAP and Salesforce is better with this ETL tool compared to other tools in the market
- Tracking Changes in slowly changing dimensions
- Fact & multi-dimensional loading
- Modularity
- Scheduling: The built-in scheduling tool has many constraints such as handling Unix/VB scripts etc. Most enterprises use third party tools for this.
- Several partnerships diminishing the value of technologies
- Unable to get list of objects from Repository (like sources & targets) that don't have any dependency
- Increased reporting strategy
- Data discovery and profiling
- Master data management
- ata lineage and data archiving
- IBM Cognos,ab initio
Because of these key features :
- Industry-leading data integration technology
- Proven best-practice implementation methodology
- End-to-end data migration services