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

Expressions Overview

Expressions Overview

You can create expressions that represent field values and filters.
Create a field expression to change the value, datatype, scale, or precision of a field. For example, you create a case-sensitive join condition between two columns that have the same values. However, the values have different cases. To match the values, you can include a field expression for each column in the join condition to convert all values to uppercase letters.
Create different types of filter expressions to increase test performance. A filter reduces the number of records that are processed in single-table or table-pair tests. For example, you can create a WHERE clause expression in a single table definition to process a subset of the records in a relational table.
You create expressions in the Expression Editor. You can manually enter an expression. Or, you can select fields, PowerCenter functions, and Data Validation Option parameters from the Expression Editor. If you create an expression for a test condition, you can also select an operator to compare two values.
When you create an expression, you must use the proper syntax based on the component that processes the expression. By default, PowerCenter processes expressions. However, you can configure the data source to process some expressions.
You must also enter a valid expression. You can validate PowerCenter expressions in the Expression Editor.
You can use one or more parameters in the WHERE clauses of table pairs and single tables. Use parameters in the WHERE clause to dynamically change the WHERE clause after each test run.