Configuration Guide

10.3 HotFix 2

Back Next

Custom Rule Types and SQL WHERE Syntax

For custom validation rules, write SQL statements that are well formed and well tuned. The SQL statement is executed as part of the WHERE condition for incoming data.

Custom validation rules decrease the performance of the load process. Use sparingly.

Use the SQL syntax that is required by your database platform. If you need more information about SQL WHERE clause syntax and wild card patterns, refer to the product documentation for the database platform that is used in your

Informatica MDM Hub

implementation.

Be sure to use parentheses to specify precedence. Incorrect or omitted parentheses can have unexpected results and long-running queries. For example, the following statement is ambiguous and leaves it up to the database server to determine precedence:

WHERE conditionA AND conditionB OR conditionC

The following statements use parentheses to explicitly specify precedence:

WHERE (conditionA AND conditionB) OR conditionC 
WHERE conditionA AND (conditionB OR conditionC)

These two statements yield very different results when evaluating records.

Validation Rule Properties

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Configuration Guide

Configuration Guide

Custom Rule Types and SQL WHERE Syntax

Custom Rule Types and SQL WHERE Syntax