Print Friendly and PDF

Data Validation Option

for PowerCenter (DVO)

onDemand | Data Integration | Self-Paced | Version 9.x

Course Overview

Discover the recommended data validation and testing methodology specifically for Data Validation Option, automatic test generation, reporting, and troubleshooting. Walk through the entire data validation and testing process, from creating simple table pairs and tests to more sophisticated data validation features and techniques.

Objectives

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

  • Explain the Data Validation Option architecture and functionality.
  • Describe the test types in general (aggregate, set and value)
  • Utilize the options that can be chosen when creating a test
  • Run tests, and evaluate test results
  • Obtain experience creating basic aggregate tests, which include COUNT, COUNT DISTINCT, COUNT ROWS, SUM, AVG, MIN, MAX.
  • Understand the value test functions, which include VALUE, and OUTER_VALUE.
  • Setup and run value tests
  • Use SET tests, which include SetA_in_B, SetB_in_A, Set_AinB, and Set_ANotInB.
  • Create SET tests

Target Audience

  • Developer
  • Data Analyst
  • Administrator

Prerequisites

  • None
Agenda
Module 1: Data Validation Option Overview
  • Obtain a high-level understanding of the Data Validation Option architecture and functionality
Module 2: Table Pairs and Table Pair Tests
  • Describe the use of table pairs in DVO
  • Describe the basic table pair tests
Module 3: Aggregate Tests
  • Describe the different aggregate tests and when these test types are most valuable
  • Describe how to run tests, and evaluate test results
  • Create basic table pairs and aggregate tests
Module 4: SET Tests
  • Develop an understanding of SET tests, which include SetA_in_B, Set_AeqB, and Set_ANotInB
  • Obtain experience creating set tests
Module 5: VALUE Tests
  • Describe value test functions, which include VALUE, and OUTER_VALUE
  • Set up and run value tests
Module 6: Expression
  • Describe how expressions can be used in testing
  • Discuss the relationship between expressions created in Data Validation Option and expressions in PowerCenter
  • Create and use expressions in tests
Module 7: Repositories
  • Describe the relationship between PowerCenter repositories and Data Validation Option repositories
  • Manage the relationship between the PowerCenter and Data Validation Option repositories
Module 8: Filtering Data
  • Describe the use of WHERE clauses and the difference between filtering on the database versus in the PowerCenter mapping
  • Describe the use of test conditions and how they function
  • Set up WHERE conditions and test conditions
Module 9: Single Table Constraints
  • Describe when to use single table constraints, and how testing with them is different than with a table
  • Set up single table constraints and associated tests
 
Module 10: Automatic Test Generation
  • Describe and work with tests that are generated automatically on either the table pair or the folder levels
Module 11: Reporting
  • Familiarize with the reporting functionality available in Data Validation Option
  • Run reports on test results
Module 12: SQL Views
  • Develop an understanding when utilizing SQL Views is advantageous
  • Create and use SQL Views in data validation situations, using the SQL View editor
Module 13: Lookup Views
  • Describe when to use Lookup Views in a data validation effort
  • Create and run tests that utilize LookupViews
Module 14: Join Views
  • Describe when to use Join Views in a data validation effort
  • Create and run tests that utilize Join Views
Module 15: Errors and Troubleshooting
  • Recognize the process the Data Validation Option engine (PowerCenter) employs to run tests and return results
  • Resolve errors in Data Validation Option
Module 16: Importing and Exporting Test Metadata
  • Describe the situations where exporting and importing Data Validation metadata could be advantageous
  • Export and import Data Validation Option metadata successfully
Module 17: Command Line Integration
  • Describe the use of the Command Line integration for DVO
  • Describe the location for the DVOCmd utility
  • Discuss the DVOCmd syntax
Module 18: Data Testing and Validation Methodology
  • Provide guideline to configure a Data Validation Option approach to testing
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