CODEWITHSUNDEEP
casedecodeinformaticainformatica-powercenter
ashish
ashish

Reputation: 17

case statement logic in informatica?

Could anyone help me to solve this problem in Informatica, I am new to Informatica, I want to build case statement logic in Informatica but the case is not available in Informatica, how to use case statements.

CASE
    WHEN E_ID = EMP_ID AND F_NAME = FIRST_NAME AND CITY = LOCATION THEN 'REJECT'
    WHEN E_ID IS NULL AND F_NAME IS NULL AND CITY IS NULL THEN 'INSERT' 
END FLAG

Thanks in advance.

Upvotes: 1

Views: 498

Answers (1)

Samik
Samik

Reputation: 3455

You could use IIF or DECODE functions in Informatica.

DECODE(TRUE, 
E_ID = EMP_ID AND F_NAME = FIRST_NAME AND CITY = LOCATION, 'REJECT',
IS_NULL(E_ID) AND IS_NULL(F_NAME) AND IS_NULL(CITY),'INSERT')

Upvotes: 2

Related Questions