Our website use cookies, which help us to improve our site and enables us to deliver the best possible service and customer experience. By clicking accept you are agreeing to our cookies policy. Find out more
If you notice any factual inaccuracies or other issues with this profile, please let us know. Please do not include any personal health information in this form.
Like Answer
IDQ (Informatica Data Quality) is a tool that can read the data from transactional sources (databases), clean the data based on the defined rules and generate analytics on required metrics. For ex: Many people provide incorrect Zipcode (Pincode) in address. IDQ can read other details from address such as city/state and correct the Zipcode.
IDQ is used to identify incorrect data and correct it. Developer will develop rules for both identifying and correcting data. IDQ mapping is run first. Once the data is corrected, then Informatica PowerCenter mapping is run which will read the data from transactional data sources and load into Data Warehouse.
IDQ main purpose is to correct the data at the source (transactional data source) itself.