This content has been marked as final. Show 2 replies
You Can use the Decode function in the Interface target columns
1 person found this helpful
RG 007 wrote:CASE when source_table.Column_A=1 then 'x'
I am moving data from one schema to another schema in Oracle 11G.
In one of my target table , in mapping I have mapped to source_table.Column_A.
This is running fine.
Now I need to change this to
if source_table.Column_A=1 then 'x' if Source_table.Column_B=1 then 'y' else if ource_table.Column_C=1 then 'z' end if.
ELSE when Source_table.Column_B=1 then 'y'
ELSE Source_table.Column_C=1 then 'z'
I am not able to make this expression in mapping.
Can somebody please advice me what is proper way to define above expression in mapping
Thanks in advance.