How to Define IF Else If Condition in OWB ?

[veldandi]

I have developed one mapping : i have 3 sources (External table) I have joined that external table using joiner and Key field. After external table i have one Expression trasformation in this Expression Builder i have defined the following If else condition in one out put attribute :
IF INGRP1.NAME IS NULL THEN
INGRP1.NAME_1
ELSE IF INGRP1.NAME_1 IS NULL THEN
INGRP1.NAME_2
ELSE INGRP1.NAME_2
END IF
/* Where INGRP1.NAME ; INGRP1.NAME_1 & INGRP1.NAME_2 are input to expression builder */

I m able to validate and Generate the mapping but i m not able to deploy the mapping. it is giving lots of warning messages in the code like L/SQL: SQL Statement ignored & From key word is missing where expected e.t.c

When i m removing this if else condition then it is successfully running the mapping and loading the data .

Hence my Query is how to define the Condition if else in the expression builder ??

 

[veldandi]

I have developed one mapping in OWB: i have 3 sources (External table) I have joined that external table using joiner and Key field. After external table i have one Expression trasformation in this Expression Builder i have defined the following If else condition in one out put attribute :
IF INGRP1.NAME IS NULL THEN
INGRP1.NAME_1
ELSE IF INGRP1.NAME_1 IS NULL THEN
INGRP1.NAME_2
ELSE INGRP1.NAME_2
END IF
/* Where INGRP1.NAME ; INGRP1.NAME_1 & INGRP1.NAME_2 are input to expression builder */

I m able to validate and Generate the mapping but i m not able to deploy the mapping. it is giving lots of warning messages in the code like PL/SQL: SQL Statement ignored & From key word is missing where expected e.t.c

When i m removing this if else condition then it is successfully running the mapping and loading the data .

Hence my Query is how to define the Condition IF ELSE IF in the expression builder ??

(Using Decode & CASE my requirement will not satisfy i want to use IF Else IF)

Thanks in Advance

 

[avjoshi]

Could you post the SQL owb generates. (You cat get that by generating intermidiate results at the expression). That will help us understand the issue better.

Anand