How to Use IF ELSE Condition in Expression Transformation
412662Jan 9 2004 — edited Feb 6 2006I have 3 source tables : I have joined using Joiner after Joiner i have Expression transformation.: In Expression i want to use IF ELSE Condition : like
IF Source1.FIELD1 IS NULL THEN
Source2.FIELD1
ELSIF Source2.FIELD1 IS NULL THEN
Source3.FIELD1
ELSE Source1.FIELD1
END IF
(where field1 , 2 & 3 R input to expression) I m able to Validate & Generate the mapping BUT at the time of Deployment it is giving Warning messages like :
PL/SQL: ORA-00923: FROM keyword not found where expected ; PL/SQL: SQL Statement ignored e.t.c.
IF i m removing IF ELSE condition then my mapping is Executing Successfully. Please provide me the solution how to use IF ELSE condition.
Thanks in Advance.
Devang Dave