2 Replies Latest reply: Nov 12, 2012 1:10 AM by Sutirtha Roy RSS

    if expression in target column mapping in interface

    RG 007
      Hi Gurus,

      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.

      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.
        • 1. Re: if expression in target column mapping in interface
          893562
          You Can use the Decode function in the Interface target columns
          • 2. Re: if expression in target column mapping in interface
            Sutirtha Roy
            RG 007 wrote:
            Hi Gurus,

            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.
            CASE when source_table.Column_A=1 then 'x'
            ELSE when Source_table.Column_B=1 then 'y'
            ELSE Source_table.Column_C=1 then 'z'
            END
            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.