{"id":48513,"date":"2018-02-21T09:49:54","date_gmt":"2018-02-21T04:19:54","guid":{"rendered":"http:\/\/blog.odango.com\/?p=48513"},"modified":"2023-02-03T09:54:57","modified_gmt":"2023-02-03T04:24:57","slug":"introduction-to-informatica-data-quality-idq","status":"publish","type":"post","link":"https:\/\/asha24.net\/blog\/introduction-to-informatica-data-quality-idq\/","title":{"rendered":"Introduction to Informatica Data Quality (IDQ)"},"content":{"rendered":"\n[et_pb_section fb_built=”1″ _builder_version=”3.22″][et_pb_row _builder_version=”3.25″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_post_title meta=”off” featured_image=”off” _builder_version=”3.0.106″ title_font=”Titillium Web||||||||” title_text_align=”left” title_text_color=”rgba(0,0,0,0.8)” title_font_size=”47″ custom_margin=”|||10%” title_font_size_tablet=”40″ title_font_size_phone=”35″ title_font_size_last_edited=”on|desktop”][\/et_pb_post_title][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”3.25″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_text _builder_version=”3.27.4″ text_font=”Titillium Web|300|||||||” text_text_color=”rgba(0,0,0,0.8)” text_font_size=”20″ text_line_height=”1.6em” max_width=”800px” max_width_last_edited=”off|phone” custom_margin=”|||10%” custom_margin_last_edited=”off|desktop” text_font_size_tablet=”” text_font_size_phone=”” text_font_size_last_edited=”on|desktop” text_line_height_last_edited=”off|phone”]

\u00a0100% Free Informatica IDQ Course, Enroll Now<\/strong><\/span><\/a><\/p>\r[\/et_pb_text][et_pb_text _builder_version=”3.27.4″ text_font=”Titillium Web|300|||||||” text_text_color=”rgba(0,0,0,0.8)” text_font_size=”20″ text_line_height=”1.6em” max_width=”800px” max_width_last_edited=”off|phone” custom_margin=”|||10%” custom_margin_last_edited=”off|desktop” text_font_size_tablet=”” text_font_size_phone=”” text_font_size_last_edited=”on|desktop” text_line_height_last_edited=”off|phone”]

\r\nInformatica Data Quality:<\/strong><\/p>\r\n

Do you want quality mass data management? Do you want a data warehouse?<\/p>\r\n

Want to prevent expensive data problems? Need more visibility and relevance?<\/p>\r\n

This blog posts I\u2019m writing today is as simple and important as it gets. I\u2019m going to introduce you to Informatica Data Quality (IDQ<\/a>) today.<\/p>\r\n

Identify, resolve, and prevent costly data problems.<\/p>\r\n

Let\u2019s dive in!<\/p>\r\n

Informatica has the largest priority for creating a data warehouse by using its powerful ETL tool, Informatica Power Center. Informatica ensures the data warehouse with quality data by providing a tool called Informatica Data Quality (IDQ).<\/p>\r[\/et_pb_text][et_pb_image src=”https:\/\/asha24.net\/blog\/\/wp-content\/uploads\/2018\/03\/1.jpg” align=”center” align_tablet=”center” align_last_edited=”on|desktop” _builder_version=”3.23″ max_width=”80%”][\/et_pb_image][et_pb_text _builder_version=”3.27.4″ text_font=”Titillium Web|300|||||||” text_text_color=”rgba(0,0,0,0.8)” text_font_size=”20″ text_line_height=”1.6em” max_width=”800px” max_width_last_edited=”off|phone” custom_margin=”|||10%” custom_margin_last_edited=”off|desktop” text_font_size_tablet=”” text_font_size_phone=”” text_font_size_last_edited=”on|desktop” text_line_height_last_edited=”off|phone”]

\r\nInformatica Data Quality provides clean, high-quality data despite size, data format, platform, or technology.<\/p>\r\n

It ensures validating and improving address information, profiling, and cleansing business data, or implementing a data governance practice, and other data quality requirements. Informatica Data Quality uses a unified platform to deliver quality data for all business initiatives and applications.<\/p>\r\n

It allows you to proactively discover, profile, monitor, and cleanse your data in a consistent and reusable manner- regardless of the underlying platform and technologies.<\/p>\r[\/et_pb_text][et_pb_image src=”https:\/\/asha24.net\/blog\/\/wp-content\/uploads\/2018\/03\/2-7.png” align=”center” align_tablet=”center” align_last_edited=”on|desktop” _builder_version=”3.23″ max_width=”80%”][\/et_pb_image][et_pb_text _builder_version=”3.27.4″ text_font=”Titillium Web|300|||||||” text_text_color=”rgba(0,0,0,0.8)” text_font_size=”20″ text_line_height=”1.6em” max_width=”800px” max_width_last_edited=”off|phone” custom_margin=”|||10%” custom_margin_last_edited=”off|desktop” text_font_size_tablet=”” text_font_size_phone=”” text_font_size_last_edited=”on|desktop” text_line_height_last_edited=”off|phone”]

Get Free Informatica IDQ Materials<\/span><\/strong><\/a><\/p>\r\n

The source data is sent to the Informatica developer tool (IDQ) for cleansing and standardizing the data which ensures the quality of the data. Then the cleansed data is sent to the Informatica power center<\/a> for loading the data from source to target tables.<\/p>\r\n

The data in the target table is sent to Informatica MDM (Master Data Management) to create the golden record (single view) of a master data.<\/p>\r\n

Data Quality Projects – Where to start?<\/strong><\/p>\r\n

Step 1:<\/strong>\u00a0Profiling the Data (Analyst Task)<\/p>\r\n

Three files\/tables exist:<\/strong><\/p>\r\n

Orders:\u00a0<\/strong>This contains Customer order information such as OrderID, PONumber, and Customer ID<\/p>\r\n

And Order and Shipping Dates<\/p>\r\n

Order Details:\u00a0<\/strong>This contains information on the actual order such as the Item number, Item<\/p>\r\n

Description and Unit Cost price.<\/p>\r\n

Customer Shipping:\u00a0<\/strong>This contains the Customer Shipping Address and customer information.<\/p>\r\n

Data profiling is used to identify problems with completeness (what data is missing), conformity<\/p>\r\n

(What data is held in non-standard format), and consistency (data in one field being inconsistent with data in another field in the same record). We need to identify the problems in the data before we can begin to cleanse and standardize it.<\/p>\r\n

Step 2:\u00a0<\/strong>Standardizing the data (Analyst and Developer Task)<\/p>\r\n

Once the data has been profiled, the analyst can identify anomalies and decide on the standardization that needs to be performed.<\/p>\r\n

These requirements can be documented within the profile which will enable analysts and developers to collaborate on projects.<\/p>\r\n

The analyst can create the reference tables that the developers need to standardize, cleanse and enrich the data. Once mapplets have been developed by the developers, they can be reviewed by the analyst and modified if required.<\/p>\r\n

The data analyst and developer can easily collaborate and transfer project related knowledge using the Analyst and Developer Tools<\/a>.<\/p>\r\n

This symbiotic transfer of information and ease of communication on projects helps reduce misunderstandings and ensure project success.<\/p>\r[\/et_pb_text][et_pb_image src=”https:\/\/asha24.net\/blog\/\/wp-content\/uploads\/2018\/03\/3-2.jpg” align=”center” align_tablet=”center” align_last_edited=”on|desktop” _builder_version=”3.23″ max_width=”80%”][\/et_pb_image][et_pb_text _builder_version=”3.27.4″ text_font=”Titillium Web|300|||||||” text_text_color=”rgba(0,0,0,0.8)” text_font_size=”20″ text_line_height=”1.6em” max_width=”800px” max_width_last_edited=”off|phone” custom_margin=”|||10%” custom_margin_last_edited=”off|desktop” text_font_size_tablet=”” text_font_size_phone=”” text_font_size_last_edited=”on|desktop” text_line_height_last_edited=”off|phone”]

\r\nStep 3:<\/strong>\u00a0Address Validation (Developer Task using input from the Analyst)<\/p>\r\n

Once the data has been cleansed and standardized the next step would be to ensure the addresses are accurate by validating and enhancing them using definitive reference data from international postal agencies. This is a developer task performed in the Developer Tool.<\/p>\r\n

Step 4:<\/strong>\u00a0Matching (Developer Task using input from the Analyst)<\/p>\r\n

Once the data has been cleansed and standardized, duplicate records can be identified using various different matching techniques. This is also a developer task performed in the Developer Tool.<\/p>\r\n

Step 5:<\/strong>\u00a0Consolidation (Developer and Analyst Task)<\/p>\r\n

Using business rules defined by the analyst, the developer can build mappings, automatically or manually, to consolidate the matched records. Automatic Consolidation: The developer can build mappings to consolidate the matched records using rules defined by the analyst.<\/p>\r\n

They can take the \u201cbest\u201d value from each field across a record and use these to create a new \u201cmaster\u201d record made up of these specially selected values.<\/p>\r\n

Manual Consolidation:\u00a0<\/strong>The developer can build mappings, using rules defined by the analyst, to populate \u201cbad records\u201d and \u201cduplicate records\u201d table in IDD (Informatica Data Director<\/a>).<\/p>\r\n

This allows tasks to be assigned to users and will enable them to manually correct bad records and consolidate duplicate records.<\/p>\r\n

To learn about tutorials, interview questions and answers, and more, read more about informatica IDQ on our\u00a0blogs<\/a>.<\/p>\r\n

Enroll for Informatica IDQ Training Course<\/strong><\/span><\/a><\/p>\r[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=”1″ _builder_version=”3.22″][et_pb_row _builder_version=”3.25″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”][et_pb_column type=”4_4″ _builder_version=”3.25″ custom_padding=”|||” custom_padding__hover=”|||”][et_pb_team_member name=”Mahesh J” position=”Author” image_url=”https:\/\/asha24.net\/blog\/\/wp-content\/uploads\/2018\/03\/123.gif” _builder_version=”3.0.106″ header_font=”Titillium Web|700|||||||” body_font=”Titillium Web||||||||” body_font_size=”16″]

\r\nHello all! I\u2019m a nature\u2019s child, who loves the wild, bringing technical knowledge to you restyled.<\/p>\r[\/et_pb_team_member][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":4,"featured_media":48517,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[40],"tags":[],"class_list":["post-48513","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-informatica-idq"],"yoast_head":"\nIntroduction to Informatica Data Quality (IDQ) - Asha24 Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/asha24.net\/blog\/introduction-to-informatica-data-quality-idq\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Introduction to Informatica Data Quality (IDQ) - Asha24 Blog\" \/>\n<meta property=\"og:url\" content=\"https:\/\/asha24.net\/blog\/introduction-to-informatica-data-quality-idq\/\" \/>\n<meta property=\"og:site_name\" content=\"Asha24 Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-02-21T04:19:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-03T04:24:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/asha24.net\/blog\/wp-content\/uploads\/2018\/03\/introduction-to-informatica-data-quality-idq-2.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"688\" \/>\n\t<meta property=\"og:image:height\" content=\"459\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mahesh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/asha24.net\/blog\/#website\",\"url\":\"https:\/\/asha24.net\/blog\/\",\"name\":\"Asha24 Blog\",\"description\":\"Dedication Towards Learning\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/asha24.net\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/asha24.net\/blog\/introduction-to-informatica-data-quality-idq\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/asha24.net\/blog\/wp-content\/uploads\/2018\/03\/introduction-to-informatica-data-quality-idq-2.jpg\",\"contentUrl\":\"https:\/\/asha24.net\/blog\/wp-content\/uploads\/2018\/03\/introduction-to-informatica-data-quality-idq-2.jpg\",\"width\":688,\"height\":459},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/asha24.net\/blog\/introduction-to-informatica-data-quality-idq\/#webpage\",\"url\":\"https:\/\/asha24.net\/blog\/introduction-to-informatica-data-quality-idq\/\",\"name\":\"Introduction to Informatica Data Quality (IDQ) - Asha24 Blog\",\"isPartOf\":{\"@id\":\"https:\/\/asha24.net\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/asha24.net\/blog\/introduction-to-informatica-data-quality-idq\/#primaryimage\"},\"datePublished\":\"2018-02-21T04:19:54+00:00\",\"dateModified\":\"2023-02-03T04:24:57+00:00\",\"author\":{\"@id\":\"https:\/\/asha24.net\/blog\/#\/schema\/person\/f6167b78bbaddfc399ae1154cd5b6759\"},\"breadcrumb\":{\"@id\":\"https:\/\/asha24.net\/blog\/introduction-to-informatica-data-quality-idq\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/asha24.net\/blog\/introduction-to-informatica-data-quality-idq\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/asha24.net\/blog\/introduction-to-informatica-data-quality-idq\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/asha24.net\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Introduction to Informatica Data Quality (IDQ)\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/asha24.net\/blog\/#\/schema\/person\/f6167b78bbaddfc399ae1154cd5b6759\",\"name\":\"Mahesh\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/asha24.net\/blog\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/085c03e75ffb51af2509c1cfad9c7d78b30236d43a008db2e46f96e2f40c67fc?s=96&d=wavatar&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/085c03e75ffb51af2509c1cfad9c7d78b30236d43a008db2e46f96e2f40c67fc?s=96&d=wavatar&r=g\",\"caption\":\"Mahesh\"},\"url\":\"https:\/\/asha24.net\/blog\/author\/mahesh\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Introduction to Informatica Data Quality (IDQ) - Asha24 Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/asha24.net\/blog\/introduction-to-informatica-data-quality-idq\/","og_locale":"en_US","og_type":"article","og_title":"Introduction to Informatica Data Quality (IDQ) - Asha24 Blog","og_url":"https:\/\/asha24.net\/blog\/introduction-to-informatica-data-quality-idq\/","og_site_name":"Asha24 Blog","article_published_time":"2018-02-21T04:19:54+00:00","article_modified_time":"2023-02-03T04:24:57+00:00","og_image":[{"width":688,"height":459,"url":"https:\/\/asha24.net\/blog\/wp-content\/uploads\/2018\/03\/introduction-to-informatica-data-quality-idq-2.jpg","path":"\/home\/reviews981\/public_html\/asha24.net\/blog\/wp-content\/uploads\/2018\/03\/introduction-to-informatica-data-quality-idq-2.jpg","size":"full","id":48517,"alt":"","pixels":315792,"type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"Mahesh","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/asha24.net\/blog\/#website","url":"https:\/\/asha24.net\/blog\/","name":"Asha24 Blog","description":"Dedication Towards Learning","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/asha24.net\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https:\/\/asha24.net\/blog\/introduction-to-informatica-data-quality-idq\/#primaryimage","inLanguage":"en-US","url":"https:\/\/asha24.net\/blog\/wp-content\/uploads\/2018\/03\/introduction-to-informatica-data-quality-idq-2.jpg","contentUrl":"https:\/\/asha24.net\/blog\/wp-content\/uploads\/2018\/03\/introduction-to-informatica-data-quality-idq-2.jpg","width":688,"height":459},{"@type":"WebPage","@id":"https:\/\/asha24.net\/blog\/introduction-to-informatica-data-quality-idq\/#webpage","url":"https:\/\/asha24.net\/blog\/introduction-to-informatica-data-quality-idq\/","name":"Introduction to Informatica Data Quality (IDQ) - Asha24 Blog","isPartOf":{"@id":"https:\/\/asha24.net\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/asha24.net\/blog\/introduction-to-informatica-data-quality-idq\/#primaryimage"},"datePublished":"2018-02-21T04:19:54+00:00","dateModified":"2023-02-03T04:24:57+00:00","author":{"@id":"https:\/\/asha24.net\/blog\/#\/schema\/person\/f6167b78bbaddfc399ae1154cd5b6759"},"breadcrumb":{"@id":"https:\/\/asha24.net\/blog\/introduction-to-informatica-data-quality-idq\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/asha24.net\/blog\/introduction-to-informatica-data-quality-idq\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/asha24.net\/blog\/introduction-to-informatica-data-quality-idq\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/asha24.net\/blog\/"},{"@type":"ListItem","position":2,"name":"Introduction to Informatica Data Quality (IDQ)"}]},{"@type":"Person","@id":"https:\/\/asha24.net\/blog\/#\/schema\/person\/f6167b78bbaddfc399ae1154cd5b6759","name":"Mahesh","image":{"@type":"ImageObject","@id":"https:\/\/asha24.net\/blog\/#personlogo","inLanguage":"en-US","url":"https:\/\/secure.gravatar.com\/avatar\/085c03e75ffb51af2509c1cfad9c7d78b30236d43a008db2e46f96e2f40c67fc?s=96&d=wavatar&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/085c03e75ffb51af2509c1cfad9c7d78b30236d43a008db2e46f96e2f40c67fc?s=96&d=wavatar&r=g","caption":"Mahesh"},"url":"https:\/\/asha24.net\/blog\/author\/mahesh\/"}]}},"_links":{"self":[{"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/posts\/48513","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/comments?post=48513"}],"version-history":[{"count":28,"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/posts\/48513\/revisions"}],"predecessor-version":[{"id":52085,"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/posts\/48513\/revisions\/52085"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/media\/48517"}],"wp:attachment":[{"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/media?parent=48513"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/categories?post=48513"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/tags?post=48513"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}