MIN - Find minimum value of number or date or string port in Informatica

MIN function is available only in Aggregator Transformation

Syntax
MIN( date or numeric or string, [filter_condition] )


Example: The following expression returns the Minimum order date for flashlights: [MIN(date)]
MIN( ORDERDATE, ITEM_NAME='Flashlight' )

ITEM_NAMEORDER_DATE
FlashlightApr 20 1998
Regulator SystemDec 15 1998
FlashlightSep 21 1998
Diving HoodAug 18 1998
Halogen FlashlightFeb 1 1998
FlashlightOct 10 1998

Output : Apr 20 1998

Example : Minimum number of quantity sold [MIN(numeric)]
MIN(quantity_sold)

ITEM_NAMEQUANTITY_SOLD
Flashlight10
Regulator System20
Diving Hood5
Halogen Flashlight27

Output : 5

Example : Minimum of String
MIN(ITEM_NAME)

ITEM_NAME
Flashlight
Regulator System
Diving Hood
Halogen Flashlight

Output : Driving Hood

For strings, MIN function is case-sensitive and sorts the string in ascending order and returns first value.