Cloud Data Quality

onDemand | Data Quality | iPaas | Self-Paced | Version R38

Course Overview

Learn the fundamentals of Informatica Intelligent Cloud Data Quality including the Cloud Architecture and GUI, Data Quality Assets/Transformations, and Cloud Mapping Designer. This course enables you to design and build your Data Quality Cloud Process for use in Data Migration, Data Integration or Data Quality Projects. This course is applicable to version R38.

Objectives

After successfully completing this course, students should be able to:

  • Describe Informatica Cloud Architecture
  • Install the secure agent
  • Describe what Cloud Data Quality and how it can be used
  • Use Cloud Administrator to define connections
  • Create Mappings using Cloud Mapping Designer 
  • Profile data to identify anomalies
  • Create Dictionaries to hold reference data for verification and standardization routines
  • Use Rule Specifications to build rules to identify bad data 
  • Identify and label data in fields using a Labeler Asset
  • Configure the Cleanse Asset to cleanse bad data identified during profiling
  • Configure the Parse Asset to parse data
  • Use the Deduplicate functionality to identify and consolidate duplicate records
  • Verify and enhance Addresses using the Verify Asset

Target Audience

  • Developer
  • Business User

Prerequisites

  • None
Agenda
Module 1: Informatica Cloud Overview
  • Introduction to Informatica Intelligent Cloud Services (IICS)
  • Informatica Cloud Terminologies
  • Informatica Cloud Architecture
  • Informatica Cloud Services
  • The Administrator Service
  • Runtime Environments
  • Connections
  • Lab: Defining Connections
  • Lab: Using Cloud Help
Module 2: Cloud Data Quality Overview
  • What is Data Quality?
  • Discuss the Data Quality Management Process Cycle
  • List and explain the Dimensions of Data Quality
  • Describe Data Quality functions, inputs, and outputs
  • Cloud Data Quality Services and Assets
Module 3: Cloud Mapping Designer
  • Cloud Mapping Designer Overview
  • Mapping Designer Terminologies
  • Common Transformations
  • Lab: Create your training folder
  • Lab: Create and run a mapping to load data into a table
Module 4: Cloud Data Profiling
  • Profile Data
  • Identify Anomalies
  • Review Profiling Results
  • Lab: Profiling Data
Module 5: Dictionaries
  • What are Dictionaries and why are they used?
  • Creating Dictionaries
  • Lab: Create a Dictionary using Value Frequencies from a profile
  • Lab: Create a Dictionary to standardize data
  • Lab: Copy and edit a Dictionary to validate data
  • Lab: Create a Dictionary to enhance data
Module 6: Rule Specifications
  • Introduction to Rule Specifications
  • Building Rule Specifications
  • Lab: Create a Rule Specification
  • Lab: Create a Rule Specification with multiple rules
  • Lab: Apply Rule Specifications to a profile
  • Lab: Create Rule Specifications to standardize data
Module 7: The Labeler Asset
  • Standardization Overview
  • Introduction to the Labeler Asset
  • Configuring a Labeler Asset for the Token Labeler
  • Configuring a Labeler Asset for the Character Labeler
  • Lab: Configure a Character Labeler
Module 8: The Cleanse Asset
  • Introduction to the Cleanse Asset
  • Cleanse, standardize and enhance data
  • Build a mapping to cleanse and transform data
  • Lab: Create a mapplet to cleanse and standardize
  • Lab: Configure a mapplet to enrich data
  • Lab: Configure a mapplet to remove noise from a numeric field
  • Lab: Configure a mapping to cleanse, standardize and enrich data
Module 9: The Parse Asset
  • Introduction to the Parse Asset
  • Parse data
  • Lab: Configure the Parse Asset in Prebuilt Mode
  • Lab: Configure the Parse Asset using a Regular Expression
  • Lab: Update the Load Mapping
  • Lab: Reprofile and standardize the data
Module 10: The Deduplicate Asset
  • Introduction to the Deduplicate Asset
  • Identify matching or related records
  • Configure the Deduplicate Asset to consolidate matched data
  • Lab: Configure the Deduplicate Asset to identify duplicate records
  • Lab: Create a mapping to identify duplicate records
  • Lab: Update the deduplicate asset to consolidate records
Module 11: The Verify Asset
  • Introduction to the Verify Asset
  • Verify Address Data
  • Lab: Configure the Verify Asset
  • Lab: Create a mapping to verify data
  • Lab: Deleting Objects


Enroll Now

Back to Course Overview

Power User Axon for Community Users (Instructor Led or onDemand) Axon Content Curation (Instructor Led) Axon for Power Users (Instructor Led) Axon Data Governance (Professional Certification) Axon Data Governance (Professional Certification) Axon Data Governance (Professional Certification) Some more content to make this bigger asdf asdf asdf

Informatica offers programs to extend learning in convenient and economic packages. Programs include self-paced subscriptions as well as bundled instructor led training and certifications. Each program is curated around a specific skillset to enable customer success.

365University Data Governance Annual Subscription

Informatica MasterPass Education Subscription

Informatica Learning Library

Data Governance & Privacy Journey Master

View Full Course Offerings