Table of Contents

Search

  1. Preface
  2. Introduction to Data Validation Option
  3. New Features and Behavior Changes
  4. Repositories
  5. XML Data Source
  6. Tests for XML Data Sources
  7. Connections
  8. Expressions
  9. Table Pairs
  10. Tests for Table Pairs
  11. Single-Table Constraints
  12. Tests for Single-Table Constraints
  13. Examples of Tests from Spreadsheets
  14. SQL Views
  15. Lookup Views
  16. Join Views
  17. Aggregate Views
  18. Business Intelligence and Reporting Tools Reports
  19. Dashboards
  20. DVOCmd Command Line Program
  21. Troubleshooting
  22. Datatype Reference
  23. Reporting Views
  24. Metadata Import Syntax
  25. Jasper Reports
  26. Glossary

Data Validation Option User Guide

Data Validation Option User Guide

Adding a Repository

Adding a Repository

You can add one target PowerCenter repository and multiple PowerCenter source repositories. Source repositories contain objects that you want to validate. Data Validation Option stores workflow objects for tests in the target repository. The associated PowerCenter user account must have Read permission on source repository connections and Read, Write, and Execute permissions on the target repository connection.
Verify that the PowerCenter Repository Service is running for each PowerCenter repository that you want to add. The corresponding PowerCenter Repository Service must be running to test the connection to a PowerCenter repository.
  1. Right-click
    INFA Repositories
    in the Navigator.
  2. Select
    Add Repository
    .
    The
    Repository Editor
    dialog box appears.
  3. Enter the repository properties.
    Set
    Contains Target Folder
    to false when you add a source repository. Set to true when you add a target repository.
  4. Click
    Test
    to test the repository connection.
    Data Validation Option verifies the connection properties. If the repository is a target repository, Data Validation Option also verifies the PowerCenter Integration Service and verifies that the Data Validation Option target folder and option results warehouse connection exist in the repository.