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_tp_view

meta_tp_view

The meta_tp_view view contains metadata about all versions of single-table constraints and table pairs. The view contains one record for each version of a single-table constraint or table pair.
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
tp_id
ID of the single-table constraint or table pair.
tp_name
Description of the single-table constraint or table pair.
tp_obj_id
ID of the single-table constraint or table pair.
tp_folder_name
Folder that stores the single-table constraint or table pair.
tp_version
Version of the single-table constraint or table pair.
tp_description
Description of the single-table constraint or table pair. Same as tp_name.
tp_time_stamp
Time that the single-table constraint or table pair was last modified. Time is represented as the number of milliseconds since 1970 UTC.
tp_comments
Comments for the single-table constraint or table pair.
tp_external_id
External ID of the single-table constraint or table pair.
tp_table_a,
tp_table_b
Name of the table or view. Table names also include the PowerCenter repository directory.
tp_conn_name_a
tp_conn_name_b
Name of the PowerCenter connection for the table or file in the single-table constraint or table pair.
tp_owner_name_a,
tp_owner_name_b
Override of the owner name for 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.
tp_where_clause_a,
tp_where_clause_b
WHERE clause for the table included in a single-table constraint or table pair.
tp_is_where_clause_dsq_a,
tp_is_where_clause_dsq_b
Indicates whether the database processes the WHERE clause. If not, the PowerCenter Integration Service performs the sampling. Contains one of the following values:
  • 0. False.
  • 1. True.
tp_join_list_str
Comma-separated list of all join fields created for the table pair. Value is null for single-table constraints.
tp_is_live
Indicates whether this version of the single-table constraint or table pair is the latest. Contains one of the following values:
  • 0. False.
  • 1. True.