The syntax of an expression varies based on the component that processes the expression.
By default, the PowerCenter Integration Service processes all expressions. You can use the PowerCenter transformation language to create PowerCenter expressions. Enter the correct case in the WHERE clause because the PowerCenter Integration Service is case sensitive. You can validate PowerCenter expressions, including expressions with parameters. If the PowerCenter syntax is not valid, a mapping installation error occurs.
You can configure the data source to process WHERE clauses. If the data source processes a WHERE clause, you must use the syntax of the data source.
For more information about PowerCenter transformation language, see the