Quality at its best - Faster and economical
March 01, 2014

Quality at its best - Faster and economical

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review

Software Version

9.5.1

Modules Used

  • Informatica developer
  • powercenter client

Overall Satisfaction with Informatica Data Quality

IDQ is used by a department at my organisation to ensure and enhance the data quality.
The usage was started with address standardization and now it had been brought to altogether 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 were affecting the sales projection and estimates.
  • 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.
  • 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
  • Character Set Mapping
  • I think its high time Informatica must integrate all tools like powercenter, IDQ, IDE , powerexhange into one which will simplify development and maintenance
  • Reduce overall project cost due to bad data , bad quality, exceptions identified nearing go-live and post production
  • Integration with tools like powercenter helped faster delivery of product at the same time conversion
  • employee efficiency is increased exponentially due to more automated, customized tool
SAP Info Steward. I have been using this tool in my past pharma organisation where the integration and target system was SAP. Though this integrates well but where far slower and had fewer quality checks than IDQ.
Customer address mismatch and bad quality is a global mess. I have strong knowledge and consistent issues with the customer addresses, names product names, codes, statuses etc. Address Doctor and duplicate check was the biggest boom 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 so much cost to the projects.

Using Informatica Data Quality

Nothing else in the market.
Integration with ETL tool like powercenter which is best and most popular in market.
Easy to Install and learn tool