Use IDQ with Power Centre to get max benefits
February 25, 2014
Use IDQ with Power Centre to get max benefits
Score 4 out of 10
Vetted Review
Verified User
Overall Satisfaction
To implement data quality to meet compliance, IDQ was selected as the tool. Currently it is being used by one department, and will gradually be used across other departments.
- IDQ does a good profiling, and it is easy to create rules.
- Use IDQ ONLY if you use Informatica Power centre as the ETL tool, else IDQ is not very effective. The major work of IDQ is called standardization, in which business can correct the data and repost the corrected data in a file, But it is possible only if IDQ is integrated with Power centre.
- There is a scorecard that provided good graphical interface to the results.
- The issue was on how badly it was implemented. All the files were uploaded to IDQ server using same file name minus the date. So IDQ wasnt able to display the historical metrics.
- The performance was too slow, with multiple users.
- While it is easy to create rules, you cannot view the actual code in the rules if it is written by someone else.
- Helped in meeting the compliance need of the organization.
- Abinitio metadata hub
It was selected by senior management.