Data Validation Option Best Practices

Data Validation Option Best Practices

Performance Testing

Performance Testing

The following tests are taken from a detailed white paper titled
Optimizing Testing Performance in the Data Validation Option
that is available from your Informatica account team. It covers performance issues and performance optimization techniques, and provides detailed execution benchmarks to help you understand the load that Data Validation Option places on the PowerCenter environment.
The following table lists the server configurations that all tests were performed on:
Component
Configuration
Operating system
Linux version 2.6.18-308.el5 (Red Hat 4.1.2-50)
CPU
AMD Opteron 6220 Processor
Speed
3000 MHz
Cores
4
Memory
128GB
Also,
  • All tests used Oracle data for both tables, table A and table B, in the table pair.
  • All tests used default configurations and were performed entirely in PowerCenter. That is, no database optimization, caching, sampling, or other performance enhancements were made.
The intention is to provide sample baseline performance numbers on a small server. Larger or more powerful servers and enabling Data Validation Option optimizations would likely result in significantly improved performance.

0 COMMENTS

We’d like to hear from you!