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

Importing Metadata

Importing Metadata

You can import Data Validation Option metadata objects. When you import metadata objects, you can edit the metadata, overwrite metadata in the Data Validation Option repository, and generate value tests.
Before you import metadata, you can configure the import file to generate value tests. For example, to generate value tests for the CustDetail_CustStage table pair, add the following lines at the end of the table pair definition in the import XML file:
<Commands> generate-tests("CustDetail_CustStage");
When you import metadata from an XML file, you can overwrite repository objects that have the same type and same name as the objects you import. If you do not overwrite objects and an object with the same name and same type exists in the repository, Data Validation Option does not import the metadata.
When you import the metadata, you can also edit the metadata. You might change the metadata based on the environment in to which you import the metadata. For example, you can change the connections, flat file locations, Data Validation Option repository, and PowerCenter repository that stores Data Validation Option objects.
  1. To generate value tests, add the generate-tests command to the end of the metadata definition for the table pair in the import XML file.
  2. To import and overwrite repository objects, select
    File
    Import Metadata (Overwrite)
    .
    The
    Import Metadata
    dialog box appears.
  3. To import metadata without overwriting repository objects, select
    File
    Import Metadata
    .
    The
    Import Metadata
    dialog box appears.
  4. Specify whether you want to edit the metadata before importing the metadata.
    If you do not edit the metadata, the Data Validation Option imports the metadata. If you edit the metadata, the
    Import Metadata
    dialog box appears.
  5. Change the metadata, and then click
    Import
    .