We have a Business Scenario where we need to use a IIF statement in expression Transformation to Satisfy the below mentioned Logic , Can any one please help me on how this can be Achieved in Informatica?
Scenario : IIF(LVL_NO=’123’AND AGNT_12_NM IS NULL ,NON_PRODR_FULL_NM,AGNT_12_NM)