Informatica Data Quality
April 11, 2014

Informatica Data Quality

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

Software Version

9.1, 9.5

Modules Used

  • Power Center, Power Exchange, IDQ

Overall Satisfaction

Informatica is used to integrate to various applications like Salesforce, SAP 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.
  • Fact & multi-dimensional loading
  • Tracking Changes in slowly changing dimensions
  • 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 discovery and profiling
  • Data lineage and data archiving
  • Increased reporting strategy
  • IBM Cognos,ssis
Proven best-practice implementation methodology
Industry-leading data integration technology
End-to-end data migration services
Connects to all major applications and databases
Right-time delivery of high-quality data
Flexibility to rapidly create and change functionality
Flexible data integration support
Informatica Data Quality provides all projects and initiatives with clean, high-quality data regardless of size, data format, platform, or technology. Less appropriate in scheduling IDQ jobs where needs to rely on third party tool. Key significance in selection process is about the efficiency of usage of tool in long term with reasonable over-head cost.