Data Validation Option for PowerCenter - On Demand (DVOPC-OD)

Data Validation Option for PowerCenter (DVO) introduces a student to the recommended data validation and testing methodology specifically for Data Validation Option, automatic test generation, reporting, and trouble-shooting. Walk through the entire data validation and testing process, from creating simple table pairs and tests to more sophisticated data validation features and techniques will be taught and supported by lab exercises.
 
Objectives
After successfully completing this course, participants 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
  • ETL Developers
  • QA Team Members
  • Data Analysts
  • Database Administrators
 
Prerequisites
  • Basic familiarity with database concepts
  • Basic SQL experience
  • Familiarity with PowerCenter is helpful, but not required
Show details
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