TrustRadius
Informatica Data Quality Review 11 of 15
Informatica Data Quality Review: "IDQ -the best cleanser!"
https://www.trustradius.com/data-qualityInformatica Data QualityUnspecified728101
Tinu Rajat profile photo
March 06, 2014

Informatica Data Quality Review: "IDQ -the best cleanser!"

Score 8 out of 101
Vetted Review
Verified User
Review Source

Software Version
9.5.1
Modules Used
Developer design

Overall Satisfaction

IDQ is used by a department at my organisation to ensure and enhance the data quality. We started with address standardization and now it had been brought to a next level of quality check where it fixes duplicates, junk characters, standardize the names, streets, product descriptions. In the past we had issues mainly with duplicate customers and products and this was affecting sales projections and estimates.
  • Better compatibility with PowerCenter. This way you can do mix- match with existing mapping rules in ETL and also value add with quality check and exception reporting
  • Address Doctor - Optimize the accuracy of your company's global address data by using the only software with all five postal certifications in one engine. It parses, cleanses, and standardizes it, then appends accurate geocodes and consumer segmentation codes for specific countries
  • Watch the data real time- After creating the job the data quality engine checks and run the custom rules creating a navigation window at the bottom for review and accessing the data right away.
  • I think its high time Informatica integrated all tools like PowerCenter, IDQ, IDE, powerexhange into one package will simplify development and maintenance
  • Integration with tools like PowerCenter helped faster delivery of product, and at the same time conversion
  • Reduce overall project cost due to bad data , bad quality, exceptions identified nearing go-live and post production
  • Employee efficiency is increased exponentially due to more automated, customized tool
There is nothing else on the market.
Integration with ETL tool like PowerCenter which is the best and most popular on the market.
Easy tool to Install and learn.
Customer address mismatch and bad quality is a global mess. I have strong knowledge of this topic and have had consistent issues with the customer addresses, names product names, codes, statuses etc. Address Doctor and duplicate check was the biggest boon for me and my organisation to overcome this hurdle. Before using IDQ, it was all manual and it was very difficult and time consuming which added a lot of cost to the projects.