2 Replies Latest reply on Jan 20, 2013 5:18 PM by aetl

    ODI evaluate variable

      Hi everyone,

      I have a question about evaluate variable:

      Now For example I have a variable:

      -No history

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

      Then Second variable:

      --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