2 Replies Latest reply: Jan 20, 2013 10:54 AM by 984374 RSS

    ODI evaluate variable

    aetl
      Hi everyone,

      I have a question about evaluate variable:

      Now For example I have a variable:

      Name:#VAR_FILE_NAME
      --Text
      -No history

      İn select -----Select first_name from hr.employees where employee_id=106 (it returns 'Valli')

      Then Second variable:

      Nanem=#VAR_CONTROL
      --Text
      --No history
      Select--- SELECT '#VAR_FILE_NAME' from dual where substr('#VAR_FILE_NAME',1,1)='V'


      Now in my package #VAR_FILE_NAME is refreshing variable

      #VAR_CONTROL is evaluate variable and compare condition is ='#VAR_FILE_NAME'

      if true then write a table else write false table.

      I want to compare two string.

      But always it is going to false table

      Where Did I made mistake?

      Thanks your reply

      Regards