MOD - Find remainder of division in Informatica

Modulus or remainder of division can be computed using modulus operator
Syntax

MOD( numeric_value, divisor )

Argument	Required/Optional	Description
numeric_value	Required	Numeric datatype. The values you want to divide. You can enter any valid transformation expression.
divisor	Required	The numeric value you want to divide by. The divisor cannot be 0.

Example

MOD( PRICE, QTY )

PRICE	QTY	RETURN VALUE
20.00	2	0
22.00	5	2
11.00	2	1
18.00	3	0
NULL	3	NULL
24.00	NULL	NULL
20.00	0	Error. Integration Service does not write row.

Contribute to Forget Code, help others. Add snippet

Introducing Radical.sh