What is most valuable?
IDQ integration with Power Centre Designer Repository. On the fly you can move your IDQ artefacts to Power Centre Designer. Later you can use them in a workflow and for scheduling etc.
How has it helped my organization?
Improved Data Quality, after we run the IDQ session which we customize for each client (Developed custom business rules in IDQ).
What needs improvement?
GUI is poor in IDQ
For how long have I used the solution?
Over a year
What was my experience with deployment of the solution?
What do I think about the stability of the solution?
What do I think about the scalability of the solution?
No (Depends upon your design and architect)
How are customer service and technical support?
Customer Service: Customer service is OKTechnical Support: Technical support is OK
Which solution did I use previously and why did I switch?
Earlier we used ODI and IDPQ, but the new client wants the development in Informatica.
How was the initial setup?
It was a ittle complex, as there are post installation services you need to create in Informaitca Administrator.
What about the implementation team?
In house team (I was part of the team as an Informatica Administrator and IDQ Developer)
What was our ROI?
Better data quality
Which other solutions did I evaluate?
IBM Data Stage, IBM Information Analyzer and IBM Quality Stage (More cost Centric). Oracle ODI (Oracle Data Integrator) and ODPQ (Oracle Data Quality and Profiling).
What other advice do I have?
Informatica Data Quality is a solid Integration tool.