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

meta_lv_view

meta_lv_view

The meta_lv_view view contains information about all lookup views and the tables included in each lookup view. The view contains one record for each table in each version of a lookup view.
For each single-table constraint, the *_a columns in the view contain information about the table on which the single-table constraint is based. The *_b columns are null for single-table constraints.
The following table describes the view columns:
View Column
Description
lv_id
ID of the lookup view.
lv_name
Internal name of the lookup view.
lv_obj_id
ID of the table in the lookup view.
lv_version
Version of the lookup view.
lv_tp_name
Name of the single-table constraint or table pair.
lv_time_stamp
Time that the lookup view was last modified. Time is represented as the number of milliseconds since 1970 UTC.
lv_comments
Comments about the lookup view.
lv_description
Description about the lookup view.
lv_table_a
Name of the source table or file.
lv_table_b
Name of the lookup table or file.
lv_type_a,
lv_type_b
Type of data source for the table or file. Contains one of the following values:
  • 1. Relational.
  • 2. Flat file.
lv_conn_name_a,
lv_conn_name_b
Name of PowerCenter connection for the table or file.
lv_owner_name_a,
lv_owner_name_b
Override for the owner name of the table or file.
lv_src_dir_a,
lv_src_dir_b
Directory that contains the file when the connection is based on a flat file or XML file. The path is relative to the machine that runs the PowerCenter Integration Service.
lv_src_file_a,
lv_src_file_b
Name of the file when the connection is based on a flat file or XML file. The file name includes the file extension.
lv_where_clause_a,
lv_where_clause_b
Not used.
lv_is_where_clause_dsq_a,
lv_is_where_clause_dsq_b
Not used.
lv_join_list_str
Comma-separated list of source-to-lookup relationships.