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

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
    .