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

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.