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

Refreshing Repositories

Refreshing Repositories

You refresh a source repository when the contents of the PowerCenter repository have changed. You usually refresh a target repository only when there are additions or changes to connection objects.
When you refresh a repository, Data Validation Option imports the source, target, folder, and connection metadata from the PowerCenter repository. Therefore, Data Validation Option objects that use changed or deleted PowerCenter objects might no longer be valid after you refresh a repository. If you created table pairs, single tables, or tests with tables that were deleted from the PowerCenter repository, Data Validation Option deletes them when you refresh the repository.
  1. To refresh all repositories at once, right-click
    INFA Repositories
    in the Navigator, and select
    Refresh All Repositories
    . To refresh one repository, right-click the repository, and select
    Refresh Repository.
  2. When you refresh one repository, you can select the objects to refresh. Select one of the following options:
    Everything
    Data Validation Option reimports all source, target, folder, and connection metadata. It updates the folder list, and the Sources and Targets folders in the Navigator.
    Connections
    Data Validation Option reimports connection metadata. Select this option when a PowerCenter user adds, removes, or updates connection objects.
    Folder List
    Data Validation Option reimports folder metadata. It updates the folder list in the Navigator. Select this option when a PowerCenter user adds or removes folders.
    Folders (Sources and Targets)
    Data Validation Option reimports source and target metadata. It refreshes the contents of the
    Sources
    and
    Targets
    folders in each folder in the repository. Select this option when a PowerCenter user adds, removes, or modifies sources or targets in folders. If the PowerCenter folder contains a shortcut to an object in another folder, you must to refresh the other folder also.
    You can also refresh repository folders individually. You might refresh a folder after you refresh the folder list and Data Validation Option imports a new folder. To refresh a repository folder, right-click the folder in the Navigator, and select
    Refresh Folder (Sources and Targets)
    . Data Validation Option refreshes the contents of the
    Sources
    and
    Targets
    folders within the folder you refresh.
    Refreshing everything in a repository or refreshing all repositories can take several minutes to several hours, depending on the size of the repositories. If you work with a small number of repository folders, you can shorten refresh time by refreshing the folders individually.