Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

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

  1. Forget Code
  2. Informatica
  3. MIN - Find minimum value of number or date port
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