Ínformatica data quality
Vinaya Kumar Reddy Thummala | TrustRadius Reviewer
Updated July 08, 2015

Ínformatica data quality

Score 10 out of 10
Vetted Review
Verified User
Review Source

Software Version

9.5.1

Modules Used

  • Developer tool,Analyst,IDD
  • Profile,data domain discovery,logical data object,mappings,mapplets,cleansing functions,address doctor,exception record management,scoreacarding,identity matching,web services,data services
  • Human tasks,classifier,data processor and all other transformations

Overall Satisfaction with Informatica Data Quality

Customer creation process - using web services for matching and address cleansing. Managing exception record management for both bad and duplicate record management. Currently using across the organization for scorecarding to cover DQ problems.
  • It's a great tool for profiling and score carding and cleansing bad data
  • Matching, standardization, address doctor, exception record management
  • Data services, web services, entity discovery, show lineage
  • Scorecard export functionality for bad records - and it only displays the first 100 records
  • There are no filtering conditions on scorecarding
  • In IDD we cannot import bad record tables or duplicate records table as we did it in 9.1
  • Profiling results should be displayed in charting mode, as with other tools
  • Cleaner data across systems
  • Better governance
Informatica data quality is better than all the products today except that competitors have better report formatting. For example: Global ID and Talend have better profiling reports for business users ( charting.. etc). Informatica is lacking in this area.
Quality check can be done across all environments but my suggestion would be that before the start of any project, the source systems must be analysed for data quality. It is much more cost-efficient to do data cleanup before the project begins.

Using Informatica Data Quality

100 - Customer,vendor,material,production. Etc
1 - etl,sql,reporting
  • Customer creation
  • Dip check
  • Cleansing functionality
  • Reports on 3rd party tools
  • On going quality check
It has great features that no other competitors offer in one product.

Evaluating Informatica Data Quality and Competitors

No - Not replaced any of the tools
  • Product Features
  • Product Usability
  • Product Reputation
  • Vendor Reputation
  • Existing Relationship with the Vendor
Product functionality

Informatica Data Quality Training

Informatica Data Quality Reliability