The Decision transformation provides access to predefined functions that you use to define decision strategies.
The Decision transformation expression editor contains a Decision folder. This folder contains functions that are specific to the Decision transformation. The editor also contains other folders that provide access to Expression transformation functions.
When you click a function in the expression editor, the transformation displays the usage and datatypes for the function, in addition to a description of what the function does.
Not all Expression transformation functions are compatible with the Decision transformation. The Decision transformation only provides access to compatible Expression transformation functions.
List of Decision Transformation Functions
ABS
ADD_TO_DATE
ASCII
CEIL
CHOOSE
CHR
CHRCODE
CONCAT
CONTAINS
CONVERT_BASE
COS
COSH
CRC32
CUME
CURDATE
CURTIME
DATE_COMPARE
DATE_DIFF
DATECONVERT
EXP
FLOOR
FV
GET_DATE_PART
GREATEST
IN
INDEXOF
INITCAP
INSTR
IS_DATE
IS_NUMBER
ISNULL
LAST_DAY
LEAST
LEFTSTR
LENGTH
LN
LOG
LOWER
LPAD
LTRIM
MAKE_DATE_TIME
MAX
MD5
METAPHONE
MIN
MOD
MONTHCOMPARE
MOVINGAVG
MOVINGSUM
NPER
PMT
POWER
PV
RAND
RATE
REG_EXTRACT
REG_MATCH
REG_REPLACE
REPLACECHR
REPLACESTR
REVERSE
RIGHTSTR
ROUND
RPAD
RTRIM
SET_DATE_PART
SIGN
SIN
SINH
SOUNDEX
SQRT
SUBSTR
TAN
TANH
TIMECOMPARE
TO_CHAR
TO_DATE
TO_FLOAT
TO_INTEGER
TRUNC
UPPER
XOR
Use a constant value to define the date format in the CURDATE, DATE_COMPARE, DATECONVERT, and MONTHCOMPARE functions in the Decision transformation.
ASK INFAPreview
