11 Replies Latest reply: Nov 8, 2012 1:01 PM by JeromeFr RSS

    Use Temp Interface as Derived Table (Sub-Select) checkbox is not enabled

    835246
      All,

      I created a yellow interface using union all (2 data sets) and i am using this yellow interface as source in a new interface.
      Use Temporary Interface as Derived Table (Sub-Select) checkbox is not enabled when i click on this yellow interface?
      Do i need to do some settings in Technology? i am using ODI 11.1.1.3 version.

      query is something like below:

      select col1,col2,... from (select col1,col2 from table1 unionall select col1,col2 from table2) inner join table3.

      Please help me... thanks in advance.