GREATEST - Find greatest value in Informatica

Greatest function returns greatest input value among the input values, and it can be a date, number or a string. And the values are case sensitive by default.

All the input values has to be of same data type i.e if first value is number and second value cannot be a date.
GREATEST(value1,[value2,........valueN,] caseFlag)

ArgumentRequired/OptionalDescription
valueRequiredAny datatype except Binary. Datatype must be compatible with other values. Value you want to compare against other values. You must enter at least one value argument. If the value is numeric, and other input values are numeric, all values use the
highest precision possible. For example, if some values are Integer datatype and others are Double datatype, the Integration Service converts the values to Double.
CaseFlagOptionalMust be an integer. Determines whether the arguments in this function are case sensitive. You can enter any valid transformation expression. When CaseFlag is a number other than 0, the function is case sensitive. When CaseFlag is a null value or 0, the function is not case sensitive.

Example : Find the maximum price
GREATEST( QUANTITY1, QUANTITY2, QUANTITY3 )

Quantity1Quantity2Quantity3Output
10203030
NULL
400010204000