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

Lookup View Properties

Lookup View Properties

Lookup view properties describe the properties of source and lookup tables.
You can view lookup view properties by selecting a lookup view in either the Navigator or on the
Lookup Views
tab and viewing the properties. Most properties come from the values entered in the
Lookup View Editor
dialog box. Other properties come from the tests set up for and run on the lookup view.
Edit lookup view properties in the
Lookup View Editor
dialog box when you add or edit a lookup view.
The following table describes the lookup view properties:
Property
Description
Table
Name of source table or lookup table. For a source table, you can use a table from any type of data source, except Salesforce, SAP, and SAS. For a lookup table, you can use a table from any type of data source, except Salesforce, SAP, SAS, and XML.
Conn
PowerCenter connection for the source table or lookup table.
Override Owner Name
Override for the owner or name of the source table.
XML Group
XML group name for an XML data source. An XML group is the parent element of one or more child elements in an XML file. Only child elements of the XML group are available to use as lookup view columns.
Description
Lookup view description.
Source Fields
Source field on which to join the source table and the lookup table.
Lookup Fields
Lookup field on which to join the source table and the lookup table.