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

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.