Table of Contents

Search

  1. Preface
  2. Introduction to Data Validation Option
  3. Repositories
  4. XML Data Source
  5. Tests for XML Data Sources
  6. Connections
  7. Expressions
  8. Table Pairs
  9. Tests for Table Pairs
  10. Single-Table Constraints
  11. Tests for Single-Table Constraints
  12. Examples of Tests from Spreadsheets
  13. SQL Views
  14. Lookup Views
  15. Join Views
  16. Aggregate Views
  17. Business Intelligence and Reporting Tools Reports
  18. Dashboards
  19. DVOCmd Command Line Program
  20. Troubleshooting
  21. Appendix A: Datatype Reference
  22. Appendix B: Reporting Views
  23. Appendix C: Metadata Import Syntax
  24. Appendix D: Jasper Reports
  25. Appendix E: 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.

0 COMMENTS

We’d like to hear from you!