1 Reply Latest reply: Jun 19, 2013 3:58 PM by Ayush Ganeriwal-Oracle RSS

    Case when condition in ODI Load Plan

    953856

      Hi All,

      Created a project variable(VAR_X) which is a text type and it can be refreshed by querying in some database.

      Created a Load Plan and added a Case step by using VAR_X

      with following logic

      Case VAR_X

      when value ='X'

           run_x_scenario.

      when value='Y'

           run_y_scenario.

      else

       

      but whenever I give start up value X or Y ,variable unable to evaluate the when condition provided in the load plan.

      always its taking else step

      Case VAR_X

      else

      but its working when I evaluate with numeric number like when value =1 etc (here I changed variable datatype to numeric)

       

      Any pointers will be appreciated.

       

      Thanks,

      Aravind