Use ERROR in expressions to validate data. Generally, you use ERROR within an IIF or DECODE function to set rules for skipping rows. You might use ERROR to keep null values from passing into a target.

You can also include ERROR in expression to handle transformation errors.

String.

The following example shows how to reference a mapping that calculates the average salary for employees in all departments of the organization, but skip negative values. The following expression nests the ERROR function in an IIF expression so that if

Data Integration

finds a negative salary in the Salary column, it skips the row and displays an error: