Abstract
Supported Versions
Data Validation Option Best Practices
General Architecture
Data Validation Option and PowerCenter Configuration
- Setting Up Data Validation Option and PowerCenter Configuration
Architecture Configuration
- PowerCenter Repository Setup
Data Validation Option Client
- Data Validation Client Overview
Naming Conventions
- Suggested Naming Conventions
User Management
Performance
- Data Validation Option Performance in PowerCenter Environment
- Performance Testing
  - Methodology and Metrics Calculations

Data Validation Option Best Practices

Back Next

Outer Value Tests

Outer value tests perform a full outer join across table A and table B in the table pair and display any orphan from either side. In general, outer value tests are performed across the key columns of the data sets and only one outer value is typically needed in given table pair. Thus, the following results show the performance for only one outer value test:

Joined	Rows	Columns	Test Types	Average Time	Rows/Sec
Yes	1,000,000	50	1 Outer Value	10 seconds	103,448
Yes	2,000,000	50	1 Outer Value	18 seconds	111,111
Yes	5,000,000	50	1 Outer Value	38 seconds	131,579
Yes	10,000,000	50	1 Outer Value	1 minute 26 seconds	116,279

Rename Saved Search

Table of Contents

Data Validation Option Best Practices

Data Validation Option Best Practices

Outer Value Tests

Outer Value Tests