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

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.