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

MIN function is available only in Aggregator Transformation

Syntax
MIN( date, [filter_condition] )


Example: The following expression returns the maximum order date for flashlights:
MIN( ORDERDATE, ITEM_NAME='Flashlight' )
ITEM_NAME         ORDER_DATE
Flashlight             Apr 20 1998
Regulator System      Dec 15 1998
Flashlight             Sep 21 1998
Diving Hood          Aug 18 1998
Halogen Flashlight     Feb 1 1998
Flashlight             Oct 10 1998

Output : Feb 1 1998