View Course Agenda

Cloud Data Quality

Instructor Led | Data Quality / iPaas | 3 Days | R37

Cloud Data Quality

Course Overview

This course is applicable to version R37. Gain the skills to design and build Data Quality Cloud Processes for use in Data Migration, Data Integration, or Data Quality Projects. Learn the fundamentals of Informatica Intelligent Cloud Data Quality, including the Cloud Architecture and GUI, Data Quality Assets/Transformations, and Cloud Mapping Designer.

Enroll Now 

Objectives

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

  • Describe Informatica Cloud Architecture
  • Install the secure agent
  • Describe Cloud Data Quality and how it is used
  • Define Connections using Cloud Administrator
  • Create Mappings
  • Profile data to identify anomalies
  • Create Dictionaries to store reference data for verification and standardization
  • Build rules to identify bad data using Rule Specifications
  • Identify data in fields using a Labeler Asset
  • Configure the Cleanse Asset to cleanse bad data identified during profiling
  • Configure the Parse Transformation/Asset to parse data
  • Verify and enhance Addresses
  • Identify and consolidate duplicate records

Target Audience

  • Developer
  • End User

Prerequisites

  • None

Agenda

Module 1: Informatica Cloud Overview

  • Informatica Cloud Services (IICS) as an iPaaS solution
  • 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 the Data Quality functions, inputs and outputs
  • Describe the Cloud Data Quality Services and Assets that are available

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 Data 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 and review
  • Lab: Create a Rule Specifications to standardize data

Module 7: The Labeler Asset

  • Standardization Overview
  • Introduction to the Labeler Asset
  • Configuring a Labeler Asset

Module 8: The Cleanse Asset

  • Introduction to the Cleanse Transformation/Asset
  • Use the Cleanse Asset to cleanse, standardize and enhance data
  • Build a mappings to cleanse and transform data
  • Lab: Create a mapplet to cleanse and standardize the Company Name
  • Lab: Configure a mapplet to enrich the data by deriving a master name prefix
  • Lab: Configure a mapping to cleanse and standardize data

Module 9: The Parse Asset

  • Introduction to the Parse Asset
  • Use the Parse Asset to parse data
  • Lab: Configure the Parse Asset using PreBuilt Mode
  • Lab: Configure the Parse Asset using a Regular Expression
  • Lab: Update the Load Mapping to include both datasets
  • Lab: Reprofile and standardize the data

Module 10: The Deduplicate Asset

  • Introduction to the Deduplicate Asset
  • Configure the Deduplicate Asset to identify matching or related records
  • Configure the Deduplicate Asset to consolidate matched data
  • Lab: Configure the Deduplicate Asset to identify duplicate or related records
  • Lab: Create a mapping to identify duplicate records
  • Lab: Update the deduplicate asset to consolidate matched records

Module 11: The Verify Asset

  • Introduction to the Verify Asset
  • Configure the Verifier Asset to Verify Address Data
  • Lab: Configure the Verify Asset to verify and correct the US master records
  • Lab: Create a mapping to verify US master records
  • Lab: Deleting Objects
 
Enroll Now 

Back to Course Overview


QUESTIONS?

Instructor Led | Data Quality / iPaas | 3 Days | Version R37

Print Friendly and PDF