Informatica Data Quality Review

We started with Firstlogic then switched to Informatica for it's ease of use.

What is most valuable?

Data cleansing and address validation are the most valuable features. Also the web services which can be called on the fly. Data Duplication plays a very important role.

How has it helped my organization?

It has improved the customer data management where we had the incorrect addresses and data cleansing. Also in finding the duplicates so as to ensure the customer data is not duplicated.

What needs improvement?

Asia pacific region address validation needs to be improved.

For how long have I used the solution?

3 years

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?


How are customer service and technical support?

Customer Service: 4 out of 5Technical Support: 4 out of 5

Which solution did I use previously and why did I switch?

We previously used Firstlogic as a data quality tool. We found that Informatica is more feasible and user friendly than Firstlogic.

What about the implementation team?


Which other solutions did I evaluate?

Yes. Trillium.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
author avatarRahulSharma5
Real User

"Salama Aleikum,

Amaze! I have been looking bing for hours because of this and i also in the end think it is in this article!""> Maybe I recommend you something helps me all the time?

Looking for a template (Excel is best) to document all the IDQ rules. The intention is that this template will be passed to the data owners to share the rules with development team in a detailed way. Look for what all attributes are must to gather.

Awesome! Thanks for putting this all in one place. Very useful!
Kind Regards,

author avatarSanjay-Kumar
TOP 20Real User


Great info! I recently came across your blog and have been reading along.
I thought I would leave my first comment. I don’t know what to say except that I have

Good luck on your test and I'd be interested to hear your testing thoughts.
Almost all function specifications I've seen so far are"> intellectual property of the respective organisation.
But you can find some templates in Velocity, the Best Practices collection provided and maintained by Informatica Professional Services.

I read multiple articles and watched many videos about how to use this tool - and was still confused! Your instructions were easy to understand and made the process simple.

Irene Hynes

author avatarRahulSharma5
Real User

Hi There,

Great post. Can’t get any more straight forward than this article. Thanks!

If you are talking about Database update statement on BO, it's a strict NO. The BO data have lots of associated data like XREF, History table which also needs to be updated along with the BO. Also, the BO tables have fields like last updated date which"> needs to be updated when any field in the record changes. If you make a DB update on one field and miss out on any of the rest, then the whole record will be corrupted.

Excellent tutorials - very easy to understand with all the details. I hope you will continue to provide more such tutorials.

Kind Regards,

author avatarGanesh Ponna

Hi Mate,

Smokin hot stuff! You’ve trimmed my dim. I feel as bright and fresh as your prolific website and blogs!

I hope there are not detailed navigation questions such as I have experienced on other Informatica tests, because who memorizes each menu path dill-down to get to some detailed setting. We have moved past the old days of having to"> Informatica IDQ training USA remember long DOS string commands. That's why we have a menu navigation system today.

THANK YOU!! This saved my butt today, I’m immensely grateful.

Thank you,

author avatarRahulSharma5
Real User

Hi There,

You make learning and reading addictive. All eyes fixed on you. Thank you being such a good and trust worthy guide.

Thank you for your helpful sugestions">Informatica IDQ training USA.
I tried the option IS_EXPR_VAR and it is treating the string as a expression.
But my requirement is that I have this expression logic changing for each record.
so I need to lookup for each record, fetch the logic and set this to mapping variable.
But when i try to set it , it gives me below error.

Excellent tutorials - very easy to understand with all the details. I hope you will continue to provide more such tutorials.

Best Regards,