Informatica - Review at a glance
March 20, 2014

Informatica - Review at a glance

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Software Version


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
The tool should satisfy these criteria:
  • Extraction of the data from legacy sources (usually heterogenous)
  • Data transformation (data optimized for transaction --> data optimized for analysis)
  • Synchronization and cleansing of the data
  • Loading the data into data warehouse.

Using Informatica Enterprise Data Integration

  • Flexible data integration support
  • Right-time delivery of high-quality data
  • Flexibility to rapidly create and change functionality