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

Expression Editor

Expression Editor

You can use the Expression Editor to create expressions. Based on the type of expression that you create, you can select fields, PowerCenter functions, and Data Validation Option parameters in the Expression Editor.
To prevent expressions that are not valid because of misspellings and syntax, you can select fields, PowerCenter functions, and Data Validation Option parameters in the Expression Editor. You can select PowerCenter functions from the
Functions
tab when you create a PowerCenter expression. If you create an expression that is processed by the data source, the
Functions
tab does not appear when you create the expression.
You can select a parameter from the
Parameters
tab when you create a WHERE clause for a single table or table pair. The
Parameters
tab shows all parameters that are defined in the parameter file that is associated with the single table or table pair. If you do not configure a parameter file for the single table or table pair, the
Parameters
tab does not appear when configure the WHERE clause.
The following figure shows a sample WHERE clause expression in the Expression Editor:
The Expression Editor shows a sample WHERE clause expression that filters employee records where the employee ID is greater than 2000. The expression also uses the UPPER function to convert the values in the EMPLOYEEID column to uppercase letters.
You can click
Validate
to validate a PowerCenter expression. The Expression Editor does not validate datatypes, precisions, scales, or expressions that the data source processes.