Introducing Radical.sh

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

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

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