9 Replies Latest reply on Jul 10, 2019 1:30 PM by Marco Fris

    ODI 12c: Using variables to populate an Knowledge Module Option

    Marco Fris

      Hi all,

       

      We are trying to use a variable to pass a value into a KM Option.

      (To make tablenames partially dynamic, in case you're wondering.)

       

      What used to work in the past:

      Create a text variable, give that value a refreshing statement to give it a value, create an Option in the KM of type = 'Value', and reference the variable in the option as '#var_name'.

      In the ODI 11g Cookbook you can find a comparable example on pages 91-92.

       

      Now, in 12c, I see the name of the variable in the generated code, instead of its value, and the mapping failing without any error message.

       

      Has anyone gotten something like this to work in 12c?

       

      Thanks,  Marco