IDQ - Simple yet effective
Updated December 10, 2014

IDQ - Simple yet effective

Shankar Reddy Akula | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Software Version

9.1.0

Modules Used

  • Informatica Developer

Overall Satisfaction with Informatica Data Quality

We are sourced from heterogeneous relational database's and also from legacy systems like SAP and SAP BW for our data integration project. After addressing multiple bugs and errors on the production data, we learned that Data Profiling and Data Quality was really missed during the analysis stage. We found many data inconsistencies, foreign character problems and issues with simple formats and formulas. Special characters were also one of the many bugs we failed to address in the beginning. Now that we start all the projects with IDQ and only after its help in analysis and fixing the bad guys, it helped us with quite a few production tickets. It also helped us with best end user experience. We are still on top of the learning curve using IDQ, but we are holding up strong with it as is now.
  • Correcting error prone manual data entry across the organization, correcting formulas, rules and methods. Understanding the data properly first to begin with. Improving and approving the accuracy overall.
  • Makes sense of our own data, which in turn gives us confidence that we can provide to the end users. IDQ helped us with erroneous data in accounting and HR for accurate and immaculate reports.
  • IDQ decreased the capital on Production support and QA time especially.
  • I did not spend any time researching the tool for improvements, but the interface with Power Center will me more interactive and connected to the developers.
  • End user experience improved and reporting needs increased with quality.
  • Decreasing the overhead on support dollars for less data related errors.
  • QA process time decreased.
Well we got used to it and it is making our data meaningful.
How the data is created and transformed today for the current business Process.
My experience is with Data Transformation and i believe it is very critical. IDQ have / has abilities to standardize the required formats and elements to include, integrate and enhance conformity.

how can the value be added retaining integrity.
Improves Parent Child relationships and Reduces Orphans scenarios. The relative information is always available and validated.

How the data can be transformed or processed for multiple areas with END to END consistency.
Typically it depends on the Data Sources, But end to end consictensy in any ETL can very well be enhanced with multiple functionalities and transformations from IDQ.