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

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.