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

SQL View Properties

SQL View Properties

You specify the SQL view properties when you create an SQL view.
The following table describes the SQL view properties:
Property
Description
Description
SQL view description.
Table Name
Name of the table included in the SQL view. All tables you use in the SQL view must exist in the same database.
Alias
Alias name for the table.
Connection
PowerCenter connection for the tables.
Column Definition
The columns that make up the SQL view. Data Validation Option imports all columns from the tables you select. You can create, delete, and rearrange columns.
SQL Statement
SQL statement you run against the database to retrieve data for the SQL view.
Comment
Information about an SQL view. Data Validation Option displays the comment when you view the SQL view in the Properties area.