IDQ Foundation Boot Camp | Informatica Data Quality (IDQ) Analyst 10.x

Course Objectives

IDQ Foundation Bootcamp is a foundation-level, hands-on course that provides students with an overview of the Informatica Data Quality Analyst tool, exploring the core Data Quality functionalities and benefits. This program can be combined with the IDQ Developer Camp to create a five-day comprehensive hands-on program.

NOTE: The Informatica Training Series is independent-format training that can be tuned and adjusted to best meet your needs. Our materials are flexible, comprehensive, and are always instructed by a senior instructor with a deep understanding of Informatica and its most current features, benefits and functionality in a wide array of uses. This is not Official Informatica Training.

Course Prerequisites

This course is geared for Business Analysts and / or developers with no prior IDQ Analyst experience.

Course Agenda

1. Data Quality Management:

• Data Quality Problems
• Data Quality Services
• Data Quality Management Process

2. Working with Analyst

• Navigating through the Analyst Interface
• Connection & Projects
• Analyst Objects
• Mapping Specification
   

3. Profiling with Analyst

• Profiling
• Creating Profiling Rules
• Create & run Scorecards
• Lab: Import Flat Files and Connect to Tables
• Lab: Profiling, Mapping Specification, Rules and Collaboration

4. Reference Table

• Definition
• Create and manage Reference tables
• Lab: Reference Table Management
• Lab: Scorecarding

5. Data Domain Discovery (Advanced Data Profiling)

• What are Data Domains
• Data Domain Discovery
• Entity Discovery
• Enterprise Discovery in Analyst tool
• Lab: Data Domain and Enterprise Discovery

6. Rule Specification

• Definition
• Features
• Rule Logic
• Validate, Test & Generate Rules mapplets
• Lab: Rule Builder

7. Project Collaboration

• Add Tags & comments on fields
• Collaboration between Analyst and Developer

Data Quality for Developer

8. Introduce the Developer Tool:

• Data Quality Management
• Setup
• Interface
• Connections

9. Developer Tool: Physical & Logical Data Objects

• Overview
• Create a Physical Data Object
  • Relational
  • Customized
  • Flat File
• Create a Logical Data Object
• Lab: Physical Data Objects

10. Developer Tool: Components

• Mappings, Mapplets
• Content Sets
• Transformations

11. Profiling with Developer:

• Options
• Column Profiling
• Mid-stream Profiling
• Comparative Profiling
• Lab: Column Profiling in Developer

12. Analyst for the Exception records:

• Update and modify the exception/duplicate records through the Analyst tool.
• Lab: Manual Consolidation

Course Materials

Each student will receive a Student Guide with course notes, code samples, software tutorials, diagrams and related reference materials and links (as applicable). Our courses also include step by step hands-on lab instructions and and solutions, clearly illustrated for users to complete hands-on work in class, and to revisit to review or refresh skills at any time. Students will also receive the project files (or code, if applicable) and solutions required for the hands-on work.