I'm new to Informatica and like to ask a question regarding infa ports. I found an example which show how to create an update flag in expression transform for updating data. The code in v_UPDATE_FLAG port looks like this:
IIF(NOT ISNULL(PREV_ITEM_KEY)
AND
(
DECODE(BONUS_FLAG,PREV_BONUS_FLAG,1,0) = 0
OR
DECODE(DISCOUNT,PREV_DISCOUNT,1,0) = 0
OR
DECODE(PRICE,PREV_PRICE,1,0) = 0
),'TRUE','FALSE'
)
Can anyone explain what this does? What the DECODE does here??
DECODE(BONUS_FLAG,PREV_BONUS_FLAG,1,0) = 0